Time

Current time

Returns the current time –> learn more

CURRENT_TIME([@time_zone])

Return type

time

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@time_zone	enum	any of: ACDT, ACST, ACT, ACT, ACWST, ADT, AEDT, AEST, AFT, AKDT, AKST, AMST, AMT, AMT, ART, AST, AST, AWST, AZOST, AZOT, AZT, BDT, BIOT, BIT, BOT, BRST, BRT, BST, BST, BST, BTT, CAT, CCT, CDT, CDT, CEST, CET, CHADT, CHAST, CHOT, CHOST, CHST, CHUT, CIST, CIT, CKT, CLST, CLT, COST, COT, CST, CST, CST, CT, CVT, CWST, CXT, DAVT, DDUT, DFT, EASST, EAST, EAT, ECT, ECT, EDT, EEST, EET, EGST, EGT, EIT, EST, FET, FJT, FKST, FKT, FNT, GALT, GAMT, GET, GFT, GILT, GIT, GMT, GST, GST, GYT, HDT, HAEC, HST, HKT, HMT, HOVST, HOVT, ICT, IDLW, IDT, IOT, IRDT, IRKT, IRST, IST, IST, IST, JST, KALT, KGT, KOST, KRAT, KST, LHST, LHST, LINT, MAGT, MART, MAWT, MDT, MET, MEST, MHT, MIST, MIT, MMT, MSK, MST, MST, MUT, MVT, MYT, NCT, NDT, NFT, NPT, NST, NT, NUT, NZDT, NZST, OMST, ORAT, PDT, PET, PETT, PGT, PHOT, PHT, PKT, PMDT, PMST, PONT, PST, PST, PYST, PYT, RET, ROTT, SAKT, SAMT, SAST, SBT, SCT, SDT, SGT, SLST, SRET, SRT, SST, SST, SYOT, TAHT, THA, TFT, TJT, TKT, TLT, TMT, TRT, TOT, TVT, ULAST, ULAT, UTC, UYST, UYT, UZT, VET, VLAT, VOLT, VOST, VUT, WAKT, WAST, WAT, WEST, WET, WIT, WST, YAKT, YEKT	false	(UTC (default))

Format time

Returns a formatted string from a time –> learn more

FORMAT_TIME(@format_string, @time_expression)

Return type

string

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@time_expression	variable or literal	any time	true	-
@format_string	literal	any string	true	(e.g., %H:%M:%S)

More details about format strings here

Parse time

Parses a time from a string –> learn more

[@safe]PARSE_TIME(@format_string, @time_string)

Return type

time

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@time_string	variable or literal	any string	true	-
@format_string	literal	any string	true	(e.g., %H:%M:%S)
@safe	boolean	any boolean	true	-

More details about format strings here

New time

Constructs a time from an hour, minute, and second –> learn more

TIME(@hour, @minute, @second)

Return type

time

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@hour	variable or literal	any integer	true	-
@minute	variable or literal	any integer	true	-
@second	variable or literal	any integer	true	-

Time add

Add a period of time to a time –> learn more

TIME_ADD(@time_expression, INTERVAL @integer_expression @time_part)

Return type

time

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@integer_expression	variable or literal	any integer	true	-
@time_part	enum	any of: hour, minute, second, millisecond, microsecond	true	((e.g., hours))
@time_expression	variable or literal	any time	true	-

Time diff

Calculate distance between two times –> learn more

TIME_DIFF(@time_expression, @time_expression_2, @time_part)

Return type

integer

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@time_expression_2	variable or literal	any time	true	-
@time_expression	variable or literal	any time	true	-
@time_part	enum	any of: hour, minute, second, millisecond, microsecond	true	((e.g., hours))

Time subtract

Subtract a period of time from a time –> learn more

TIME_SUB(@time_expression, INTERVAL @integer_expression @time_part)

Return type

time

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@integer_expression	variable or literal	any integer	true	-
@time_part	enum	any of: hour, minute, second, millisecond, microsecond	true	((e.g., days))
@time_expression	variable or literal	any time	true	-

Time truncate

Truncates a time to the nearest boundary –> learn more

TIME_TRUNC(@time_expression, @time_truncate_part)

Return type

time

Parameters

Name	Type	Allowed values	Required	Placeholder (in UI)
@time_expression	variable or literal	any time	true	-
@time_truncate_part	enum	any of: hour, minute, second, millisecond, microsecond	true	((e.g., hours))