AW: sysdate

From: Libal, Ivo <ivo.libal_at_knapp-systems.com>
Date: Tue, 24 Oct 2000 17:01:59 +0200
Message-Id: <10659.120039@fatcity.com>

sysdate-1/86400

86400=3D24*60*60=20

> -----Urspr=FCngliche Nachricht-----
> Von: Poosapati Varma [SMTP:psgkv_at_yahoo.com]
> Gesendet am: Dienstag, 24. Oktober 2000 16:50
> An: Multiple recipients of list ORACLE-L
> Betreff: sysdate

>=20

> Hi guys,

>=20

> 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

>=20

> Varma.

>=20


> __________________________________________________

> Do You Yahoo!?
> Yahoo! Messenger - Talk while you surf! It's FREE.
> http://im.yahoo.com/
> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --=20
> Author: Poosapati Varma
> INET: psgkv_at_yahoo.com

>=20


> 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).
Received on Tue Oct 24 2000 - 10:01:59 CDT