SQLTeam.com | Weblogs | Forums

Date and time

sql2008

#1

Hi,
I just create a schedule table which on of the information contain from date until date. But I still don't have idea of putting the time because the time should I put into the from date and until date or I must create another 2 field maybe time1 and time2 to store the time information.
May be you guys have a better solution of those problems..please tell me..

thx


#2

Sorry this is so late but here goes. The Date/Time should be together and the entries would be like
2017-03-14 11:00:00
2017-04-19 20:23:00