Snippet Name: TIMESTAMP: DUMP Description: Returns the number of bytes and datatype of a value (in this case the SYSTIMESTAMP). 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: DBTIMEZONE » TIMESTAMP: Get current timestamp » TIMESTAMP: List time zones Comment: (none) Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 04th, 2009
Description: Returns the number of bytes and datatype of a value (in this case the SYSTIMESTAMP).
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: DBTIMEZONE » TIMESTAMP: Get current timestamp » TIMESTAMP: List time zones
DUMP(<value>) SELECT DUMP(SYSTIMESTAMP) FROM dual;