EasyCFM.COM ColdFusion Forums / MS SQL Server Related Issues / comparision of two times value in sql server 2005

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: comparision of two times value in sql server 2005

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

angrycoder
07-05-2008 @ 1:02 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
New Member
Posts: 39
Joined: Apr 2008

Hi Guys
can u give me some ideas how to compare the two times fields in sql server. I have a attendance table inwhich a field attedance_date_time is there. I want to count those records which has the time after 9:45AM.


Thanks in advance

Scarecrow
08-06-2008 @ 1:43 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Junior Member
Posts: 109
Joined: Oct 2004

The following query should get you started...

Select count(*) As recordCount
From TableName
Where dateTimeColumn > '2008-08-06 09:45'


Ken

www.scarecrowapplications.com


Website Designed and Developed by Pablo Varando.