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 |
|
Martin.Silsby
Starting Member
1 Post |
 Posted - 2008-07-25 : 12:36:26
|
| I want to do a search on a date in a data base but only the Day/month e.g. all dates of the 31/01 but all years so i think i need to change to date field to a text field but i dont know how |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2008-07-25 : 12:40:57
|
| SELECT *FROM yourTableWHERE MONTH(dateField) = 1 and DAY(datefield) = 31Jim |
 |
|
|
|
|
|
change a date to text