Re: PLEASE HELP
From: victor <victor_at_PERCOMBANK.KIEV.UA>
Date: 3 Dec 1998 11:33:06 GMT
Message-ID: <01be1eb0$c16fa770$6b14abcc_at_victor>
Date: 3 Dec 1998 11:33:06 GMT
Message-ID: <01be1eb0$c16fa770$6b14abcc_at_victor>
Steven <koh_cc_at_pacific.net.sg> wrote in article
<366732CB.FF636D0_at_pacific.net.sg>...
> hi,
>
> May l know how to make use any date function,
>
> in order to insert a date format of
>
> DD-MON-YYYY e.g 01-Mar-1998
>
> current date in datebase is 01-Mar-98
>
> (not 2000 compliance)
>
> Thank you
>
> --
> With regards
> Steven
>
> Steven Koh, Internet Software Engineer,
>
>
>
01-Mar-98 is only representation of data in db
(its stored in number format )
and when you want to see 01-Mar-1998 try to use
to_char(data,'dd-mon-yyyy') or to_char(data,'dd.mm.yyyy')
Received on Thu Dec 03 1998 - 12:33:06 CET