UTCNOW function - Amazon Quantum Ledger Database (Amazon QLDB)

UTCNOW function

Returns the current time in Coordinated Universal Time (UTC) as a timestamp.

Syntax

UTCNOW()

This function requires that you specify a FROM clause in a SELECT query.

Arguments

None

Return type

timestamp

Examples

SELECT UTCNOW() FROM << 0 >> -- 2019-12-27T20:12:16.999Z SELECT UTCNOW() FROM Person WHERE GovId = 'LEWISR261LL' -- 2019-12-27T20:12:26.999Z INSERT INTO Person VALUE { 'firstName': 'Jane', 'createdAt': UTCNOW() } UPDATE Person p SET p.updatedAt = UTCNOW() WHERE p.firstName = 'John'

Related functions