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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-16 : 17:11:11
|
Querien writes "I was wondering if it's possible to select those fields where a given month is in that datetime field. E.g. something like select * from news where DateCreate > DATEPART("m",'9/21/2000')
I'm looking to get al the records created after september while putting in a full date. Is this possible? I know I mis-used DATEPART in this matter, but i'm looking for something simular.
Sorry if this is a dumb question.
Kind regards Querien" |
|
|
|
|
|
Selecting records in a datetime fields passing only a month or a year