Skip to content
Advertisement

Tag: database-agnostic

DB agnostic SQL for CURRENT_TIMESTAMP

I’m currently using Oracle, but most of the SQL is db agnostic. One exception is CURRENT_TIMESTAMP which fails in MSSQL. Is is possible to move to a more portable syntax for this too? Answer According to their documentation the following vendors support CURRENT_TIMESTAMP. Oracle Postgresql MySQL SQL Server Firebird H2 HSQLDB DB2 Vertica InterSystems Caché Doctrine Teradata In summary, CURRENT_TIMESTAMP

Advertisement