Hello!

Is there a way to store a time like: 8:00-9:00
or do I have to store 2 "hours" like 8:00 (hour 1) and 9:00 (hour2) in my row "starthour" and "endhour"

I want in an easy way to be able to compare booked hours so I would really like to have time in a format like xx:xx-yy:yy

Thanks for helping me // D_S

the only way to store both times in one field is as a string

if you want to do range checking, yes, use two TIME fields

if the booked hours can ever span more than one day, use two DATETIME fields

You can store it as a character string, but you can't store it as a single datetime value. Either store the StartTime and the EndTime, or the StartTime and the Duration.

Ok, thank you!