Re: ORACLE DATES - How to use them

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Thu, 03 May 2007 14:31:09 GMT
Message-ID: <Nmm_h.297610$6P2.238697@newsfe16.phx>

tracy <usatracy_at_hotmail.com> wrote in news:1178172606.252558.70190 @p77g2000hsh.googlegroups.com:

> I am pulling data from Oracle into MS-Access, when run all of the date
> fields are just a lot of numbers and not dates, if I link them in
> Access or pass through query it is the same.
>
> I get numbers like 1178002042 in the date field.
>

IIRC, these values are standard Unix "epoch" Timestamps seconds since 1 Jan 1970 GMT

Do straight foward math transformation to get into Oracle date datatype Received on Thu May 03 2007 - 09:31:09 CDT