meta data for this page
  •  

F_STRTOTIME

compatibility to FreeUDFLibC

Entrypoint strtotime compatible with UTF-8

Inputs/Outputs

   Input      CSTRING(11)     British/American time (f.e. 05:04:01 AM) as string
   Output     TIME            time in format 24 hours

Syntax

   Inputformat could be with one or two digits and the separation from AM/PM with or without blanks, AM/PM must be entered in capital letters.
   TestSQL   
   SELECT '05:04:01' AS ISCORRECT, F_STRTOTIME('05:04:01 AM') FROM RDB$DATABASE;
   SELECT '17:04:01' AS ISCORRECT, F_STRTOTIME('5:4:1PM') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_STRTOTIME(NULL) FROM RDB$DATABASE;