CURRENT TIMESTAMP function 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