CURRENT_UTC_DATE function returns the system date in UTC (Coordinated Universal Time).

Syntax

CURRENT_UTC_DATE

Returns

  • UTC System date in form: YYYY-MM-DD

Examples

SELECT CURRENT_UTC_DATE
FROM "redshift1.inventory.sampleData"

-- Could return
2013-08-20