No expert in SQL, I’m having great difficulty finding the syntax of firebird and in particular its functions. Is there a good reference to the version of firebird used in Base v6?
Then how do I use the DATEDIFF function (which appears to be different to the forme HSQLDB)? I have in a SELECT statement:
DATEDIFF( year, “DOB”, “TestDate”) “Age”
but it is creating SQL syntax error.
Any advice appreciated.