Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 04th, 2009
SYSTIMESTAMPSELECTSYSTIMESTAMPFROM dual;-- The systimezone function might return a value like this:
03-11-2120:4-- You can also choose to use the to_char function with -- the systimestamp function. For example:SELECTTO_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.
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.