在MS Access 2013中使用SQL将日期与当前日期进行比较
问题描述:
我在ms Access 2013中有一个表.它的列名称expirydate具有日期值.我需要写一个满足以下条件的查询 expirydate大于当前日期. 谁能告诉我该怎么做?
I have a table in ms access 2013. It has a column name expirydate having date values. I need to write a query with the following condition expirydate is greater than current date. Can anyone tell me how can i do this?
答
我假设您可以使用SQL查询:
I'm supposing that you can use SQL query :
SELECT * FROM table_name WHERE expirydate > Date()