Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: epoch()
If U mean where U use to_date('01/01/99','mm/dd/yy') should be year 1999 and
not 2099 use RRRR or RR
ie.
to_date('01/01/99','mm/dd/rr') this will return 1999
to_date('01/01/01','mm/dd/rr') this will return 2001
Gabriel Millerd wrote:
> Anyone have a procedure or simular to convert the date to the epoch
> time?
>
> ---
> Gabriel Millerd | I know not with what weapons World War III will be
> Plumber | fought, but World War IV will be fought with
> http://sabbat.org| sticks and stones. -Albert Einstein
--
55 Broadway - 21st Floor
New York, New York 10006
Phone: 800.221.5327 x2136
Fax: 212-825-2245
E-Mail: MWeinstock_at_lds.com
Web: http://www.lds.com
Received on Tue Jan 18 2000 - 09:04:54 CST