meta data for this page
  •  

F_STRIPDATE

compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP

input/output-compatibility to rFunc (EXTRACTTIME)

Entrypoint stripdate compatible with UTF-8

Inputs/Outputs

   Input      TIMESTAMP     date optionally time
   Output     TIMESTAMP     timestamp with date 31.12.1899 (date 0) with chosen time

Syntax

   To get only the time use CAST(' 01.10.2005 15:00:00' AS TIME)
   TestSQL
   SELECT '31.12.1899 15:00:00' AS ISCORRECT, F_STRIPDATE(' 01.10.2005 15:00:00')
   FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_STRIPDATE(NULL) FROM RDB$DATABASE;