var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Store time in format xx:xx-yy:yy
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.