meta data for this page
  •  

F_SECOND

compatibility to FreeUDFLibC, GrUDF

input/output-compatibility to rFunc (EXTRACTSECOND)

Entrypoint second compatible with UTF-8


Inputs/Outputs

   Input      TIMESTAMP      date optionally time 
   Output     INTEGER        seconds of the timestamp

Syntax

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