meta data for this page
F_C_DECTIME2TIME
convert from SI-units
function from adhoc
decimal-time to time
Syntax
Test SQL SELECT 17.45 AS ISCORRECT, F_C_TIME2DECTIME('03.11.2008 17:27:00') FROM RDB$DATABASE; SELECT 0 AS ISCORRECT, F_C_TIME2DECTIME(CURRENT_DATE) FROM RDB$DATABASE; SELECT NULL AS ISCORRECT, F_C_TIME2DECTIME(NULL) FROM RDB$DATABASE; SELECT '17:27:00' AS ISCORRECT, F_C_DECTIME2TIME(17.45) FROM RDB$DATABASE; SELECT '17:27:18' AS ISCORRECT, F_C_DECTIME2TIME(17.455) FROM RDB$DATABASE; SELECT '17:27:19' AS ISCORRECT, F_C_DECTIME2TIME(17.4552777) FROM RDB$DATABASE; SELECT '17:27:30' AS ISCORRECT, F_C_DECTIME2TIME(17.45833333) FROM RDB$DATABASE; SELECT '17:54:00' AS ISCORRECT, F_C_DECTIME2TIME(17.90) FROM RDB$DATABASE; SELECT '00:00:00' AS ISCORRECT, F_C_DECTIME2TIME(0) FROM RDB$DATABASE; SELECT NULL AS ISCORRECT, F_C_DECTIME2TIME(NULL) FROM RDB$DATABASE; SELECT 17.45 AS ISCORRECT, F_C_TIME2INDTIME('03.11.2008 17:27:00') FROM RDB$DATABASE; SELECT 17.45 AS ISCORRECT, F_C_TIME2INDTIME('03.11.2008 17:27:29') FROM RDB$DATABASE; SELECT 17.46 AS ISCORRECT, F_C_TIME2INDTIME('03.11.2008 17:27:30') FROM RDB$DATABASE; SELECT '17:27:00' AS ISCORRECT, F_C_INDTIME2TIME(17.4580555555556) FROM RDB$DATABASE; SELECT '17:28:00' AS ISCORRECT, F_C_INDTIME2TIME(17.4583333333333) FROM RDB$DATABASE;