The Remedy DATE fields match up with the Oracle Julian format
select to_date(2456797,'J') from DUAL
5/19/2014
Fred
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of LJ LongWing
Sent: Wednesday, March 30, 2016 10:35 AM
To: [email protected]
Subject: Re: DATE field value in Oracle calculation
**
Keith,
I'm not in front of a computer at the moment, but searching the archives or on
communities will give you the formula for days only fields
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Sinclair, Keith
Sent: Wednesday, March 30, 2016 9:52 AM
To: [email protected]
Subject: DATE field value in Oracle calculation
**
I know DATETIME fields store the value as epoch time. However, when I look into
the value for a DATE only field value, I get "2456797", which doesn't seem to
match epoch time. How does this get stored and is there a formula that can be
applied to the value to calculate the value to display the proper DATE in a
human readable- format?
Example: START_DATE in the database stored as 2456797, needs to display an
Oracle DATE type of 5/19/14.
Keith Sinclair
Remedy Development
ShopperTrak Chicago, USA
O 312.676.8289
[email protected] | shoppertrak.com
Retail Profitability, Improved.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
