meta data for this page
  •  

F_MILLISECOND

input/output-compatibility to rFunc (EXTRACTMILLISECOND)

Entrypoint millisecond compatible with UTF-8

Inputs/Outputs

   Input      TIMESTAMP     date optionally time 
   Output     INTEGER       milliseconds of the timestamp

Syntax

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