开发者

Mysql get things after certain date

开发者 https://www.devze.com 2023-04-06 13:48 出处:网络
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

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

精彩评论

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