Geek Answers Handbook

DB agnostic SQL for CURRENT_TIMESTAMP

I am currently using Oracle, but most of SQL is db agnostic. The exception is CURRENT_TIMESTAMP, which does not work in MSSQL. Is it possible to switch to a more portable syntax?

+7
sql database-agnostic
source share
1 answer

According to their documentation, the following providers support CURRENT_TIMESTAMP .

In conclusion, CURRENT_TIMESTAMP is the method specified in the SQL standard, the summary of which is given below, and if you are looking for SQL agnostic SQL, you can best do this, adhere to the standard, although this does not guarantee that something will be completely aggregated DB:

6.32 <datetime function function>

Function

Specify a function giving a value of type datetime.

Format

 <current date value function> ::= CURRENT_DATE` <current time value function> ::= CURRENT_TIME [ <left paren> <time precision> <right paren> ] <current local time value function> ::= LOCALTIME [ <left paren> <time precision> <right paren> ] <current timestamp value function> ::= CURRENT_TIMESTAMP [ <left paren> <timestamp precision> <right paren> ] <current local timestamp value function> ::= LOCALTIMESTAMP [ <left paren> <timestamp precision> <right paren> ]

General rules

1) s CURRENT_DATE, CURRENT_TIME and CURRENT_TIMESTAMP respectively return the current date, current time and current time stamp; time and timestamp values ​​are returned with a timezone offset equal to the current default SQLsession timezone offset.

+8
source share

More articles:


All Articles