|
Posted by eddiekwang on 10/20/06 00:34
Thank you for the information!!!
Kart wrote:
> Check this link
>
> http://databases.aspfaq.com/general/why-doesn-t-sql-server-allow-me-to-separate-date-and-time.html
>
> eddiekwang@hotmail.com wrote:
> > Hello,
> > I need to store the start and end time of each weekly class into a
> > database. so that people can easily search for classes based on time.
> > for example, someone might want to search all classes that are offered
> > between 9am and 2pm.
> >
> > How can i implement this time field? i don't have a date to store with
> > the hour and minutes. is there and way sql server can tell 2pm is
> > bigger than (>) 9am?
> >
> > thank you in advance,
> > eddy
Navigation:
[Reply to this message]
|