Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: In Oracle is there any function for TIMESTAMP?
sysdate
refer to the sql reference manual for further details about the so-called 'pseudo'-functions.
Hth,
Sybrand Bakker, Oracle DBA
"Globalink" <wasiq_at_ibos.com> wrote in message
news:mscp5.215$1I4.10147_at_newsfeed.intelenet.net...
> Hi, i'm porting a db from MS SQL 7 to Oracle 8i
> on Win NT 4.0.
>
> In MSSQL i have a column of type datetime and default value
> getDate() which returns current date and time.
>
> What is the function in Oracle which returns timestamp in Oracle?
>
>
> Thanks
> Wasiq Hasan
>
>
>
Received on Thu Aug 24 2000 - 12:35:26 CDT