Snippet Name: TIMESTAMP: Get current timestamp Description: Produces the current timestamp. Equivalent to NOW() in mySQL. Also see:» FUNCTIONS: date/time » TIMESTAMP: TZ_OFFSET » TIMESTAMP: TRUNC » TIMESTAMP: SysTimeStamp » TIMESTAMP: SYS_EXTRACT_UTC » TIMESTAMP: SessionTimeZone » TIMESTAMP: LocalTimestamp » TIMESTAMP: FROM_TZ » TIMESTAMP: EXTRACT » TIMESTAMP: DUMP » TIMESTAMP: DBTIMEZONE » TIMESTAMP: List time zones Comment: (none) Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 04th, 2009
Description: Produces the current timestamp. Equivalent to NOW() in mySQL.
Also see:» FUNCTIONS: date/time » TIMESTAMP: TZ_OFFSET » TIMESTAMP: TRUNC » TIMESTAMP: SysTimeStamp » TIMESTAMP: SYS_EXTRACT_UTC » TIMESTAMP: SessionTimeZone » TIMESTAMP: LocalTimestamp » TIMESTAMP: FROM_TZ » TIMESTAMP: EXTRACT » TIMESTAMP: DUMP » TIMESTAMP: DBTIMEZONE » TIMESTAMP: List time zones
CURRENT_TIMESTAMP SELECT CURRENT_TIMESTAMP FROM dual; -- Create table with different TIMESTAMP columns CREATE TABLE date_table ( time_stamp_tz TIMESTAMP WITH TIME ZONE, time_stamp_ltz TIMESTAMP WITH LOCAL TIME ZONE);