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 |
|
globemast
Starting Member
32 Posts |
 Posted - 2004-04-28 : 17:19:10
|
| Hello...I am using ASP using SQL in order to keep a record for some information that i want for my work. I insert my date in table: Stats and at the time i also insert the current date using the mm/dd/yyyy format in the CrDate field of my Stats table.Now what i want to do exactly is to have a list menu in my ASP program and use it to find my records per month.For example if i choose May i want the SQL to return me all the records which there date is during May.How can i analyze my dates in order to do that? Is there a way i can query SQL in such a way that it returns me the date broken down in day / month /year.Thank you. |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-04-28 : 17:26:07
|
| WHERE DATEPART(MM,datecolumn) = 5MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
Checking for Month and Year ???