Recht übersichtlich
Zitat von
Datumsfunktionen:
Function
Description
CURRENT_DATE
Returns the current date
CURRENT_TIME
Returns the current time
CURRENT_TIMESTAMP
Returns the current local date and local time as a timestamp value
NOW
Returns current date and time as a timestamp value
SYSDATE
Returns current date and time as a timestamp value
TOSTRING
Converts date and time to string
TODATE
Converts string to date and time
EXTRACT
Extracts datepart component from datetime value as INTEGER