meta data for this page
  •  

F_STRIPTIME

compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP

input/output-compatibility to rFunc (EXTRACTDATE)

Entrypoint striptime compatible with UTF-8

Inputs/Outputs

   Input      TIMESTAMP     date optionally time
   Output     TIMESTAMP     timestamp with time 00:00:00 from chosen date

Syntax

   To get only the date use CAST(‘01.10.2005 15:00:00' AS DATE)
   TestSQL
   SELECT '01.10.2005 00:00:00' AS ISCORRECT, F_STRIPTIME(' 01.10.2005 15:00:00')
   FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_STRIPTIME(NULL) FROM RDB$DATABASE;