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 |
|
Amber_Deslaurier
Starting Member
40 Posts |
 Posted - 2010-06-26 : 20:30:01
|
| Hi,I would like my query to have a where clause that would restrict output to the current Year (2010) and Current Month (6) and current day (26)what is the correct syntax?***([My fields] are in brackets)***where [Date] = currentYear and [Month] = currentMonth and [Day] = currentDay ???TYAmber. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Amber_Deslaurier
Starting Member
40 Posts |
Posted - 2010-06-26 : 21:05:07
|
| yes Tara I would but since its a view that is developed by another organization I have no way of challanging their architecture... I do need to extract their data but I need to ensure I extract based on the criteria identified... is their keywords for Current Year and current month that I can use successfully? Thanks. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SQL SERVER CURRENT DATE