469,129 Members | 1,725 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,129 developers. It's quick & easy.

need help on store and compare time?

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

Oct 19 '06 #1
2 3378
Check this link

http://databases.aspfaq.com/general/...-and-time.html

ed********@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
Oct 19 '06 #2
Thank you for the information!!!
Kart wrote:
Check this link

http://databases.aspfaq.com/general/...-and-time.html

ed********@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
Oct 20 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Mad Scientist Jr | last post: by
reply views Thread by KK | last post: by
6 posts views Thread by Mike Hoff | last post: by
21 posts views Thread by Johan Tibell | last post: by
reply views Thread by U S Contractors Offering Service A Non-profit | last post: by
9 posts views Thread by Paul | last post: by
7 posts views Thread by Kesavan | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.