topflight Posted February 11, 2010 Share Posted February 11, 2010 Hello I have a table called called flights where it has all my flights info. But in that table I have a column called time. I want to put pull a random 15 flights who time is 30mins from the current time. For instance if the current time is 4:30 I want to pull a random 15 rows who time is 35 mins from now(Which is 4:30) how can I do that. Thanks in advanced! P.S my time format is in 24 hours. One of the times in the database are 1735, I do not have any ":" between numbers Quote Link to comment Share on other sites More sharing options...
mapleleaf Posted February 11, 2010 Share Posted February 11, 2010 Do it with MYSQL http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html Quote Link to comment Share on other sites More sharing options...
topflight Posted February 11, 2010 Author Share Posted February 11, 2010 can you please like write an example query statement please. Quote Link to comment Share on other sites More sharing options...
topflight Posted February 11, 2010 Author Share Posted February 11, 2010 any other suggestions? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.