LOCALTIMESTAMP function in oracle

By Santhosh N

This explains how to get the current date and time in the time zone of the current SQL session which is set by the Alter session command.

There is function by the name, LOCALTIMESTAMP for fetching the current Date and Time set by the Alter Session command in the current time zone.

Syntax: LOCALTIMESTAMP

Ex: SELECT LOCALTIMESTAMP from DUAL;
This returns something like ‘5/18/2010 3:28:26.458148 AM -07:00’

Note: The value returned will be changed based on the alter session command issued for the session.

Related FAQs

This explains how to convert the timestamp value to the timestamp with time zone in oracle.
This explains how to get the Database Time zone information that is set to the current session.
This explains how to find the number of months between two dates in oracle
This explains how to add the number of months to a given date in oracle
This explains how to get the last day of the month from the specified date in oracle
As the table, dba_scheduler_jobs contains columns with date and as they are stored with timezone information, it sometimes causes issue while querying in oracle.
LOCALTIMESTAMP function in oracle  (1469 Views)