开发者

Mysql get things after certain date

So, I have a database table holding tickets. One of the fields is "availableUntil".

when I make the database call to get tickets, I want to be able to exclude those tickets who's date has already been passed relative to the current dat开发者_StackOverflow社区e.

Anyone know of a way to do this?


SELECT blablabla... WHERE availableUntil >= CURRENT_TIMESTAMP


SELECT [what_you_want] FROM your_base WHERE availableUntil > CURRENT_DATE();
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜