Chapter 12 – Date Functions

"An inch of time cannot be bought with an inch of gold."

- Chinese Proverb

Current_Date

image

The Current_Date will return today's date.

TIMEOFDAY()

TIMEOFDAY() returns a VARCHAR data type and specifiesthe weekday, date, and time.

SELECT TIMEOFDAY() ;

timeofday

------------

Mon Oct 6 22:53:50.333525 2014 UTC

“Always remember that you are unique just like everyone else.”

– Anonymous

The TIMEOFDAY function returns the weekday, date and the time.

SYSDATE Returns a Timestamp with Microseconds

This example uses the SYSDATE functionto return the full timestamp for the current date.

This example uses the SYSDATE function ...

Get Actian Matrix (Formely ParAccel) - Architecture and SQL now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.