Okay I finally found it… I used DATEADD (ss, <name of Remedy date field>, ‘19700101’) in the sql.
SELECT last_modified_date ,dateadd(ss, last_modified_date, '19700101') FROM HPD_Help_Desk WHERE …. How it looks: J *From:* Nancy Tietz [mailto:[email protected]] *Sent:* Friday, June 08, 2012 10:47 AM *To:* [email protected] *Subject:* question on format of Remedy dates in SQL Server Hi all – I’m wondering how I convert my date fields so that I can understand them in sql server: Example: SELECT last_modified_date , convert(varchar(40), last_modified_date, 100) FROM HPD_Help_Desk WHERE Incident_Number = 'INC000000031823'; I expected the above ‘Convert’ to fix the Last_modified_date integer field into the readable format, but it didn’t. Thank you for your help! I’m using ARUtilities’s SQL tool to query the data. Thank you! Nancy _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
<<image001.png>>
