Date/Time Functions

Contact Us or call 1-877-932-8228
Date/Time Functions

Date/Time Functions

The SYSDATE function returns the current system date and time. Oracle includes a variety of globalization options to support various regions and time zones. The SESSIONTIMEZONE function can be used to return the time zone for the current session. It either returns a time zone offset (a character type in the format '[+|]TZH:TZM') or a time zone region name. See Oracle's Globalization Support documentation for details.

Next