Re: In Oracle is there any function for TIMESTAMP?

From: <pmohanan_at_my-deja.com>
Date: Thu, 24 Aug 2000 17:41:30 GMT
Message-ID: <8o3mo5$31f$1@nnrp1.deja.com>

Hi..Wasiq,

you can use sysdate which will return you the date/timestamp.

sql> select sysdate from dual;
or
sql> select to_char(sysdate,'mm/dd/yyyy HH:MI:SS') from dual;

Hope this helps.

Regards,

Praveen

In article <mscp5.215$1I4.10147_at_newsfeed.intelenet.net>, "Globalink" <wasiq_at_ibos.com> wrote:
> 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
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Aug 24 2000 - 12:41:30 CDT