Converting Remedy Datetime for SQL Query

2006-10-30 Thread James Van Sickle
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

Re: Converting Remedy Datetime for SQL Query

2006-10-30 Thread Webster, Basil
: 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

Re: Converting Remedy Datetime for SQL Query

2006-10-30 Thread Carlos Ungil
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