Posted by Kart on 10/19/06 20:05

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

• Next in forum: Re: How do you conditionally fire a trigger (mimic replication)
• Prev in forum: need help on store and compare time?
• Thread view: Re: need help on store and compare time?

[Reply to this message]