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