meta data for this page
  •  

F_HOUR

compatibility to FreeUDFLibC, GrUDF

input/output-compatibility to rFunc (EXTRACTHOUR)

Entrypoint hour compatible with UTF-8

Inputs/Outputs

   Input      TIMESTAMP      date optionally time 
   Output     INTEGER        hours of the timestamp

Syntax

   If you entered only date, the hour is = 0.
   TestSQL
   SELECT 14 AS ISCORRECT, F_HOUR('23.08.2004 14:38:12') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_HOUR(NULL) FROM RDB$DATABASE;