meta data for this page
  •  

F_C_INDTIME2TIME

convert from SI-units

function from adhoc

industrial 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;