Common datetime call

[jca...@gmail.com]

Hi,

Does a means exist to generically call a local datetime func such that it renders as SYSDATE in Oracle and GETDATE() in SQL Server?

Thanks,

jlc

[Simon King]

Do you need those functions explicitly? I think both databases support
the CURRENT_TIMESTAMP function (which you'd access as
sqlalchemy.func.current_timestamp()).

If you really do want to use different functions based on the
database, the compiler extension is what you want:

https://docs.sqlalchemy.org/en/14/core/compiler.html#utc-timestamp-function

Hope that helps,

Simon

[Joseph L. Casale]

Hi Simon,

I originally was relying on a utc datetime and was surprised to see that was

inconsistent with the rest of the application. As surprising as it, I do need a

local time and your example is perfect.

Thank you very much!

jlc