sql中日期的比较
How to compare date in SQL? For example, the ‘users’ table has a column ‘loggin’ which is the date and time. How to find out the ‘users’ whose ‘loggin’ date is later than Jan 10, 2017?
如何在SQL中比较日期? 例如,“用户”表的“ loggin”列是日期和时间。 如何找出“登录”日期晚于2017年1月10日的“用户”?
In SQL, dates can be compared using ‘’, ‘<=‘ and ‘>=‘.
在SQL中,可以使用'',“ <=”和“> =”比较日期。
For the example described, the SQL statement could be:
对于所描述的示例,SQL语句可以是:
SELECT *
FROM users
WHERE login > ‘2017-01-10’
Related references as follows.
相关参考文献如下。
For the date string https://en.m.wikipedia.org/wiki/ISO_8601
对于日期字符串 https://en.m.wikipedia.org/wiki/ISO_8601
翻译自: https://www.systutorials.com/how-to-compare-date-in-sql/
sql中日期的比较