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
On March 30, 2016 9:07:50 AM "Sinclair, Keith" <[email protected]>
wrote:
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]<mailto:[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"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
