sql 日期函数
-- MySQL、PostgreSQL、SQLite
SELECT CURRENT_DATE AS today;
today |
----------|
2020-10-14|
-- Oracle
SELECT CURRENT_DATE AS today
FROM dual;
TODAY |
-------------------|
2020-10-14 08:22:55|
-- SQL Server
SELECT CAST(GETDATE() AS DATE) AS today;
today |
----------|
2020-10-14|