Quick Search:
 
 Oracle PL/SQL: Current_timestamp Jump to:  
Category: >> Oracle PL/SQL >> Current_timestamp  

<< lastnext >>

Snippet Name: Current_timestamp

Description: The current_timestamp function returns the current date and time in the time zone of the current SQL session as set by the ALTER SESSION command. It returns a TIMESTAMP WITH TIME ZONE value.

Also see:
» Check Constraint: Create
» Unique Constraint
» Primary Key Constraint
» Foreign Key Constraints
» Deferring Constraint Checking
» Add Primary Key Constraint example
» Constraint Checks
» Add constraint example

Comment: (none)

Language:
Highlight Mode: PLSQL
Last Modified: February 28th, 2009

SELECT CURRENT_TIMESTAMP FROM dual;
 
returns something LIKE 17-Sep-09 10.50.24.853421 PM -07:00
 
 


 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org