CURRENT_UTC_TIMESTAMP functions returns the system timestamp in UTC (Coordinated Universal Time).

Syntax

CURRENT_UTC_TIMESTAMP

Returns

  • UTC System time in form: YYYY-MM-DD HH:MM:SS.SSS

Examples

SELECT CURRENT_UTC_TIMESTAMP
FROM "redshift1.inventory.sammpleData";

-- Could return
2013-09-20 04:35:14.934