Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: epoch()

Re: epoch()

From: Marc Weinsock <MWeinstock_at_lds.com>
Date: Tue, 18 Jan 2000 15:04:54 GMT
Message-ID: <3884813E.EBBAA7B9@lds.com>


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

--



Marc Weinstock
Logical design Solutions

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US