meta data for this page
  •  

F_ENCODETIMESTAMP

compatibility to GrUDF

Entrypoint encodetimestamp compatible with UTF-8

Inputs/Outputs

   Input     INTEGER     year
             INTEGER     month
             INTEGER     day
             INTEGER     hours
             INTEGER     minutes
             INTEGER     seconds
   Output    TIMESTAMP   timestamp build from parameters

Syntax

   TestSQL
   SELECT '20.02.2004 09:45:53' AS ISCORRECT, F_ENCODETIMESTAMP(2004, 2, 20, 9, 45, 53) FROM RDB$DATABASE;
   SELECT '20.02.2004 00:00:00' AS ISCORRECT, F_ENCODETIMESTAMP(2004, 2, 20, 0, 0, 0) FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_ENCODETIMESTAMP(NULL, NULL, NULL, NULL, NULL, NULL) FROM RDB$DATABASE;