SQL Querry for Getting CurrentTimeStamp

, ,
1

Hi All

I need to get the current timestamp from the database by using sql querry.

Can anyone help me out

Thanks
Sreeni

2

select current_timestamp from dual; This is supported in 9i. Hope yours is 9i if not get back.

Cheers!!!