datetime queries - SQL Server Forums

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)

datetime queries

Author

Topic

c_mesimer
Starting Member

3 Posts

Posted - 2001-04-19 : 12:09:21

I need to run a query on a datetime field where the user enters the year and the month.
My field looks like: 2001-01-01 00:00:08.000
How do I just query on the year and month?

Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources