Wiki / Operators

convert date and time with time zone to timestamp with time zone

Left operand

date

Right operand

timetz

Result type

timestamptz

Implementing function

datetimetz_pl(date,timetz)

Operator kind

Binary

Hash join candidate

no

Merge join candidate

no

aliases

+, +(date,timetz)

manual semantics

Source catalog description; no additional matching manual operator definition claimed

memberships

Unknown

signature

+(date,timetz) → timestamptz

source oid

1361

{"commutator":"+(timetz,date)","function":"datetimetz_pl(date,timetz)","hash_join":"f","kind":"b","left_type":"date","merge_join":"f","negator":"","result_type":"timestamptz","right_type":"timetz","symbol":"+"}