ChrisM@Work (6/24/2013)

---

avishain (6/24/2013)

---

J Livingston SQL (6/24/2013)

---

do you have any other columns available that hold date info ...eg yyymmdd?

also what are you expecting to happen when the end time is two or more days after the start time

I DO HAVE ANOTHER COLUMNS

Date_StartHour_StartDate_EndHour_End

2011062110423220110621121805

as you can see, i got 2 columns referring to the date and 2 columns referring to the time (exact hour)

the date format is yyyymmdd

the time format is hhmmss

thank you for helping 🙂

What datatype are the columns?