Fellow ARSList Members
I need to convert the Epoch time format that Remedy stores its datetime
data into a more readable format for an SQL query. According to an older
KB article I have from Remedy, Remedy recommends using DATEADD(day,
h.Cinsert field id-2440588, '01/01/1970') to format
: Converting Remedy Datetime for SQL Query
Fellow ARSList Members
I need to convert the Epoch time format that Remedy stores its datetime
data into a more readable format for an SQL query. According to an older
KB article I have from Remedy, Remedy recommends using DATEADD(day,
h.Cinsert field
Hello,
I don't think you can use them (Oracle 9i is required and I understand
you're using MS SQL), but for the record here are a couple of
functions I wrote recently to convert remedy timestamps to/from a more
reasonable format.
Regards,
Carlos Ungil
create function timestamp_to_date
3 matches
Mail list logo