开发者

How to order events close to today's date

I have a table that stores events with the php timestamp format. I would like to get the next 10 events.

SELECT * FRO开发者_Go百科M myTBL WHERE event_time >= TODAY ORDER BY (The closest time to today)

Any help on writing this query would be greatly appreciated.


SELECT * FROM myTBL WHERE event_time >= TODAY ORDER BY event_time ASC
0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜