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!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

between time frame problem

Status
Not open for further replies.
JOBARAM

JOBARAM

Programmer
May 25, 2002
52
IL
Hi helper,
I have Start and End columns, type Time.
I need to do something when the current time is in between Start and End.
I use the following:

DATE_FORMAT(now(),'%H:%i:%s') Between Start AND End

It works great if the time in the same day, it does'nt work if Start is 23:00:00 and End 10:00:00 (the next day).
How can I do it work if I cannot change the type of Start and End to DateTime?
Please advise.
Thanks
Jo
 
Status
Not open for further replies.

Similar threads

Darryl Johnson
  • Locked
  • Question
Adding labor hours to a date time field
Replies
5
Views
205
Andrzejek
Andrzejek
KL_Hutchmfg
  • Locked
  • Question
Getdate to sum the total of time frame
Replies
3
Views
127
ChrisHirst
ChrisHirst
Prochotap
  • Locked
  • Question
How to sumarize “sickness time” to the end of order - mysql
Replies
0
Views
87
Prochotap
Prochotap
tyutghf
  • Locked
  • Question
between date range ignoring 0000-00-00
Replies
4
Views
77
jpadie
jpadie
Bilberry
  • Locked
  • Question
sum total hours between datetime stamp 1
Replies
7
Views
239
jpadie
jpadie

Part and Inventory Search

Sponsor

Back
Top