Entrypoint stripdate compatible with UTF-8
Input TIMESTAMP date optionally time Output TIMESTAMP timestamp with date 31.12.1899 (date 0) with chosen time
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;