We are using functions that from a reply Thomas Bean posted to the ARS Llist on 10/2/07 with the subject "Convert Date in to timestamp in remedy". These function take into account DST. They are setup for CST but easily modified for PST (same as us).
Let me know if you would like me to forward the email to you. Jason On Wed, Nov 5, 2008 at 1:19 PM, Eli Schilling <[EMAIL PROTECTED]>wrote: > ** Hey list! > > I was wondering if anyone out there is using reporting services or direct > SQL to report out of the ARSYstem database. If so, how are you dealing with > the date conversion and daylight savings time? > > I'm using the following to convert the date time (i'm in the PST time zone) > dateadd(ss, (convert(int, b.T4))+(3600*-8), '01-01-1970 00:00:00') > > So during the summer I do (3600*-7) but then for daylight savings I have to > go -8. > > Thanks! > > Eli > > > The contents of this message, together with any attachments, are intended > only for the use of the individual or entity to which they are addressed and > may contain information that is legally privileged, confidential or > otherwise exempt from disclosure. If you are not the intended recipient, you > are prohibited from disseminating, distributing, or copying this message or > any attachment. If you have received this message by mistake, please let the > sender know by email reply and immediately delete this message, along with > any attachments, from your system. Thank you. > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
