Snippet Name: Current_timestamp Description: The current_timestamp function returns the current date and time in the time zone of the current SQL session as set by the ALTER SESSION command. It returns a TIMESTAMP WITH TIME ZONE value. Also see:» Check Constraint: Create » Unique Constraint » Primary Key Constraint » Foreign Key Constraints » Deferring Constraint Checking » Add Primary Key Constraint example » Constraint Checks » Add constraint example Comment: (none) Language: Highlight Mode: PLSQL Last Modified: February 28th, 2009
Description: The current_timestamp function returns the current date and time in the time zone of the current SQL session as set by the ALTER SESSION command. It returns a TIMESTAMP WITH TIME ZONE value.
Also see:» Check Constraint: Create » Unique Constraint » Primary Key Constraint » Foreign Key Constraints » Deferring Constraint Checking » Add Primary Key Constraint example » Constraint Checks » Add constraint example
SELECT CURRENT_TIMESTAMP FROM dual; returns something LIKE 17-Sep-09 10.50.24.853421 PM -07:00