Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ORDER BY - datetime
That sounds like a super solution! Let me just try it and I'll get back to it thanks so far -
ORDER BY - datetime
You might be right. Do you have a possible solution like the one you suggested yourself? Like this: so you just want to have concerts having the "start date" tomorow between 00:00 and 05:00 to be displayed in the today's listing? -
ORDER BY - datetime
To help the users...I would rather show todays concerts between 00:00 and 05:00 after 23:59 the same day. If that is possible. -
ORDER BY - datetime
Yes! That is exactly what I want to do. I am displaying concerts for each day. The problem is that the concerts taking place after midnight is displayed first in my listing. So you are absolutely right. Can you help me? -
ORDER BY - datetime
Hello experts I am trying to a list of "events" from a field which contains datetime. I am ordering it by date, but I also want it to have a sorting-order that does NOT start from:00:00:00 to 23:59:59 but instead sorts the "events" from eg. 05:00:00 to 04:59:59. Can anybody help me?
