Wiki / Operators

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

Left operand

timetz

Right operand

date

Result type

timestamptz

Implementing function

timetzdate_pl(timetz,date)

Operator kind

Binary

Hash join candidate

no

Merge join candidate

no

aliases

+, +(timetz,date)

manual semantics

Source catalog description; no additional matching manual operator definition claimed

memberships

Unknown

signature

+(timetz,date) → timestamptz

source oid

1366

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