meta data for this page
  •  

F_RENCODEDATETIME

input/output-compatibility to rFunc (ENCODEDATETIME)

Entrypoint r_encodedatetime compatible with UTF-8

Inputs/Outputs

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

Syntax

   Input-parameter in other order than F_ENCODETIMESTAMP
   TestSQL
   SELECT '20.02.2004 09:45:53' AS ISCORRECT, F_RENCODEDATETIME(20, 2, 2004, 9, 45, 53) FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_RENCODEDATETIME(NULL, NULL, NULL, NULL, NULL, NULL)) FROM RDB$DATABASE;