Re: In Oracle is there any function for TIMESTAMP?

SYSDATE is the pseudo variable, you can assign it as a default value to your column. as per the following:

create table t (
  name varchar2(100)
, start_date date default sysdate )
/

insert into t (name) values ('Globalink');

set nls_date_format='YYYYMMDD HH24:MI';

select * from t;

;) guy

Globalink 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
Received on Tue Sep 19 2000 - 10:24:33 CDT