Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Stored Procedure - Time

Author  Topic  baranpd Starting Member 1 Post Posted - 2001-02-12 : 10:06:36 hi, I currently have a field in my DB that is smallDateTime and I am writing a stored proc that will compare the time passed in to the time in the field. Now it compares the dates?? How can I ignore the date and somehow parse it so it just compares the times?? Thanks !!!!