Re: Timestamps with Oracle
From: Randy Dewoolfson <randyd_at_cais.com>
Date: 1995/10/14
Message-ID: <45ovvn$dp7_at_zippy.cais.net>#1/1
Date: 1995/10/14
Message-ID: <45ovvn$dp7_at_zippy.cais.net>#1/1
INTEGRATA AG (integrata_at_access.ch) wrote:
: Hi there,
: i am wondering wether it is possible to use a command like
: 'select TIMESTAMP from dummyTab'
: within Oracle7.
:
: If so, how does it work and what format must a field have to receive
: this information
:
: Thanx in advance
:
: H. Kiesswetter
:
SELECT sysdate FROM DUAL; returns a date/time value down to the
second. (Use to_char to convert it to whatever you want)
select hsecs from v$timer to get 1/100th seconds.
-- ..uu. ---------------------- .?$" '?i . I Randy DeWoolfson I .T^M ._at_" d9 . f ,.un. b, i I--------------------I " Z :#" M `8 U < .dP"``"# `M _at_" I randyd_at_cais.com I &H?` Xl _R $5. $ ?* _at_ 'P,#" I--------------------I ,d#^*L :RP'~$b f`$L:M Xf .f' dH` I ,\//. I & 'M ,P `E M "$ Mux~ n!` I |o o| I dk `h" ' j " y" *~ I====oOO==(_)==Ooo===IReceived on Sat Oct 14 1995 - 00:00:00 CET