Re: How to convert Oracle native Date to date time

tracy wrote:
> I get numbers like 1178002042 instead of date time info when I run
> access againt oracle.
>
> Does anyone know what the math is to convert this to date time, I
> assume it is telling me the number of seconds past some arbirtrary
> point in time like midnight 1-1-1980 ?
>
> Does anyone know what this arbitrary point in time is, if so I can
> work with the date time info as delivered via my current connection
> and applications.
>
> Thanks

I agree with everyone else about doing a describe on the table and posting your SQL. Also include your version number.

But for anyone interested in what the numbers mean there is a description in Morgan's Library at www.psoug.org under Data Types.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org