471,594 Members | 1,611 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,594 software developers and data experts.

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 3425
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
reply views Thread by XIAOLAOHU | last post: by
reply views Thread by leo001 | last post: by
reply views Thread by Anwar ali | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.