I know there are a million ways to handle the issue of epoch time stored in the ARS database. Another to add to the mix is BMC Analytics. It provides a function (FN_ADJUSTED_DATE) and associated meta-data tables to provide the translation with full timezone and dst support.
select incident_number,assigned_group,fn_adjusted_date(Reported_Date) as Reported_Date from hpd_help_desk where assigned_group = 'Remedy' INCIDENT_NUMBER ASSIGNED_GROUP REPORTED_DATE 1 INC000000074125 Remedy 04/08/2008 6:03:03 PM 2 INC000000074032 Remedy 04/29/2008 1:00:07 PM 3 INC000000074033 Remedy 04/29/2008 1:00:06 PM 4 INC000000074034 Remedy 05/15/2008 12:47:39 PM Thought I would share because it is nice to have something that is both supported by BMC (if you own Analytics) and useful. Tony Worthington | Sr. Technical Analyst | Kohl?s Department Stores N56 W17000 Ridgewood Drive | Menomonee Falls, WI 53051 | office: (262) 703-7763 | e-mail: tony.worthing...@kohls.com ********************************************************************** CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages by authorized Kohl's Associates at any time without any further consent. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"