CoderZone.org

Category: >> Oracle PL/SQL >> TIMESTAMP: DUMP Bookmark and Share

<< lastnext >>

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)

Author: CoderZone
Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 04th, 2009

DUMP(<value>)
 
SELECT DUMP(SYSTIMESTAMP) FROM dual;
 
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© coderzone.org | users online: 7