question on format of Remedy dates in SQL Server

[Nancy Tietz]

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"