meta data for this page
  •  

F_TZVALUETOUTC

function from adhoc

Entrypoint tzvalue_to_utc compatible with UTF-8

Inputs/Outputs

   Input      none	
   Output     DOUBLE     Diff of local datetime to UTC (universal time code) in hours

Syntax

   TestSQL
   SELECT CAST(DATEDIFF(MINUTE, CURRENT_TIMESTAMP, F_LOCAL2UTC(CURRENT_TIMESTAMP)) / 60 AS DOUBLE PRECISION) 
   AS ISCORRECT, F_TZVALUETOUTC() FROM RDB$DATABASE