SEARCH

 

LOCALTIMESTAMP Function

LOCALTIMESTAMP returns a TIMESTAMP value.

You can specify an optional integer argument to specfiy the precision of the second field.

Example:

SELECT LOCALTIMESTAMP FROM DUAL;

LOCALTIMESTAMP
----------------------------
13-SEP-05 03.02.49.407000 PM

Add your comments or share tips on LOCALTIMESTAMP

 

Top

 
   Copyright © 2002-2008 OracleHome.co.uk All rights are reserved.