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 = 'INC00031823'; I expected the above ‘Convert’ to fix the

Re: question on format of Remedy dates in SQL Server

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:nti...@umich.edu] *Sent:* Friday, June 08,

Re: question on format of Remedy dates in SQL Server

Nancy, I create the below function in my system for reference CREATE FUNCTION [dbo].[RemedyDateTimeToHuman] (@DateToConvert as int) RETURNS datetime AS BEGIN return DateAdd(s, @DateToConvert, '1/1/1970') END Then in my select I use select dbo.RemedyDateTimeToHuman(last_modified_date)

Re: question on format of Remedy dates in SQL Server

Thanks LJ ! -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, LJ CTR MDA/IC Sent: Friday, June 08, 2012 11:09 AM To: arslist@ARSLIST.ORG Subject: Re: question on format of Remedy dates in SQL Server Nancy, I create