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 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) FROM HPD_Help_Desk By doing it in a function, I don't need to remember the syntax every time :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Nancy Tietz Sent: Friday, June 08, 2012 8:59 AM To: arslist@ARSLIST.ORG Subject: Re: question on format of Remedy dates in SQL Server ** Okay I finally found it... I used DATEADD (ss, , '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, 2012 10:47 AM To: arslist@arslist.org 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 = 'INC00031823'; 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 _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ __ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
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) FROM HPD_Help_Desk By doing it in a function, I don't need to remember the syntax every time :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Nancy Tietz Sent: Friday, June 08, 2012 8:59 AM To: arslist@ARSLIST.ORG Subject: Re: question on format of Remedy dates in SQL Server ** Okay I finally found it... I used DATEADD (ss, , '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, 2012 10:47 AM To: arslist@arslist.org 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 = 'INC00031823'; 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 _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: question on format of Remedy dates in SQL Server
Okay I finally found it… I used DATEADD (ss, , ‘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, 2012 10:47 AM *To:* arslist@arslist.org *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 = 'INC00031823'; 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" <>