Returns a timestamp the current day and time on the Cirro Data Hub.

Syntax


CURRENT_TIMESTAMP

Returns

  • YYYY-MM-DD HH:MM:SS.SS

Additional Information

  • CURRENT TIMESTAMP and CURRENT_TIMESTAMP perform the same function and can be used interchangeably.

Examples


SELECT CURRENT_TIMESTAMP
FROM "redshift1.inventory.sampleData";

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