You are here: need help on store and compare time? « MsSQL Server « IT news, forums, messages
need help on store and compare time?

Posted by eddiekwang on 10/19/06 19:30

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]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация