From Oracle to FireBird – a comparison of functions
We have made an comparison of functions between Oracle and FireBird to avoid the nice (but incomplete) UDF-library UDF4Ora. Most of the Oracle functions are similar to FireBird- or FreeAdhocUDF-functions. Here you find a complete liste of comparison.
If you are interested in one (or more) not presented functions send an eMail to help@freeadhocudf.org.
Christoph Theuring / FreeAdhocUDF.org
Loading...
Seems outdated wrt. FB 2.5.
GREATEST -> MAXVALUE
LEAST -> MINVALUE
REMAINDER -> MOD – not sure if it’s completely equivalent
ROUND -> ROUND
TRUNC -> TRUNC
USER -> CURRENT_USER
TRUNC(CURRENT_DATE), TRUNC(SYSDATE) -> CURRENT_DATE
CURRENT_DATE, SYSDATE, CURRENT_TIMESTAMP -> CURRENT_TIMESTAMP
DENSE_RANK, RANK -> FB 3
MAX -> MAXVALUE – don’t think it is
MIN -> MINVALUE – don’t think it is
CURRENT_DATE, CURRENT_TIMESTAMP -> nothing – ?
Adriano, you are mostly right 🙂
GREATEST -> MAXVALUE
LEAST -> MINVALUE
REMAINDER -> MOD not right
with MOD you can use only integer params
ROUND (numbers) -> ROUND
ROUND (dates) -> not present
TRUNC (numbers) -> TRUNC
TRUNC (dates) -> not present
USER -> CURRENT_USER is not exactley the same but can be used for same cause
TRUNC(CURRENT_DATE) does not run (FB 2.5)
CURRENT_DATE … not the same as CURRENT_TIMESTAMP in FB. Oracle returns a TIMESTAMP with TIMEZONE. Timezones are not present at time in FB 🙁
MAXVALUE AND MINVALUE could also be uses with 2 expressions so it’s equal to MAX/MIN
The website is updated. Thanks for watching.
Christoph
Christoph, when replying to some comment, I suggest you to use the [Reply] link, so the original commenter gets an email notification that someone replied to his comment, and the talk gets “threaded” 😉