URRENT DATE function returns the current date on the Cirro Data Hub.

Syntax

CURRENT_DATE

Returns

System date in form: YYYY-MM-DD HH:MM:SS.SS

Additional Information

  • CURRENT DATE and CURRENT_DATE perform the same function and can be used interchangeably.

Examples

SELECT CURRENT_DATE
FROM "redshift1.inventory.sampleData";

-- Could return
2012-05-09 22:29:30.63