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: [email protected]
**********************************************************************
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:[email protected] ARSlist: "Where the Answers Are"
