Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

TIMEOFDAY Function

TIMEOFDAY is a special alias used to return the weekday, date, and time as a string value.

Syntax

Copy
TIMEOFDAY()

Return Type

VARCHAR

Examples

Return the current date and time by using the TIMEOFDAY function:

Copy
select timeofday(); timeofday ------------ Thu Sep 19 22:53:50.333525 2013 UTC (1 row)