RE: sysdate

From: Poosapati Varma <psgkv_at_yahoo.com>
Date: Tue, 24 Oct 2000 10:33:23 -0700 (PDT)
Message-Id: <10659.120066@fatcity.com>

hi paul,

thanks for the statement it really helped a lot.

varma.
--- Paul van Dijken <paul.vandijken_at_sema.nl> wrote:
> After setting the NLS_DATE FORMAT to DD-MON-YYYY
> HH24:MI:SS, try this:
>
> select sysdate a, (sysdate - 1/(24*60*60)) b from
> dual;
> A B
> -------------------- --------------------
> 24-OCT-2000 16:54:46 24-OCT-2000 16:54:45
>
> Paul
>
> -----Original Message-----
> Sent: 24 October 2000 16:50
> To: Multiple recipients of list ORACLE-L
>
>
> Hi guys,
>
> How do we update a field with sysdate - 1 second.
> say for example we have 23-oct-00 09:30:09
> how can we get 23-oct-oo 09:30:08
>
> Varma.
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Messenger - Talk while you surf! It's FREE.
> http://im.yahoo.com/
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Poosapati Varma
> INET: psgkv_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists

>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Paul van Dijken
> INET: paul.vandijken_at_sema.nl
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists

>

Do You Yahoo!? Received on Tue Oct 24 2000 - 12:33:23 CDT