meta data for this page
F_ADDHOUR
function from adhoc
Entrypoint addhour compatible with UTF-8
Inputs/Outputs
Input TIMESTAMP date optionally time INTEGER hours to add Output TIMESTAMP adds hours to timestamp
Syntax
If parameter 2 is negative, hours where subtract. TestSQL SELECT '01.10.2005 18:03:01' AS ISCORRECT, F_ADDHOUR('01.10.2005 15:03:01', 3) FROM RDB$DATABASE; SELECT '01.10.2005 12:03:01' AS ISCORRECT, F_ADDHOUR('01.10.2005 15:03:01', -3) FROM RDB$DATABASE; SELECT NULL AS ISCORRECT, F_ADDHOUR(NULL, NULL) FROM RDB$DATABASE;