Snippet Name: TIMESTAMP: SysTimeStamp
Description: The systimestamp function returns the current system date and time (including fractional seconds and time zone) on your local database.
Also see:
» FUNCTIONS: date/time
» TIMESTAMP: TZ_OFFSET
» TIMESTAMP: TRUNC
» TIMESTAMP: SYS_EXTRACT_UTC
» TIMESTAMP: SessionTimeZone
» TIMESTAMP: LocalTimestamp
» TIMESTAMP: FROM_TZ
» TIMESTAMP: EXTRACT
» TIMESTAMP: DUMP
» TIMESTAMP: DBTIMEZONE
» TIMESTAMP: Get current timestamp
» TIMESTAMP: List time zones
Comment: (none)
Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 04th, 2009
|
SYSTIMESTAMP
SELECT SYSTIMESTAMP
FROM dual;
-- The systimezone function might return a value like this:
03-11-21 20:4
-- You can also choose to use the to_char function with
-- the systimestamp function. For example:
SELECT TO_CHAR(SYSTIMESTAMP, 'SS.FF')
FROM dual;
-- The function above may return a value such as:
41.550774
-- The valid format options for seconds are 'SS', 'SSSSS', and 'FF'.
-- Using 'SS' returns whole seconds.
-- Using 'SSSSS' returns milliseconds.
-- Using 'FF' returns fractional seconds. |
