Groups
Groups
Sign in
Groups
Groups
comp.databases.ms-sqlserver
Conversations
About
Send feedback
Help
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Learn more
SQL Date expressions
12 views
Skip to first unread message
contracer
unread,
Apr 17, 2013, 10:17:20 AM
4/17/13
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
Hi,
How could I create these sql expressions ?
last 7 days
last 30 days
last month
last week
this year
last year
Thanks
bradbury9
unread,
Apr 17, 2013, 10:50:08 AM
4/17/13
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
Using TSQL date functions, here is a list:
http://msdn.microsoft.com/en-us/library/ms186724.aspx
Most usual functions are GetDate(), DatePart() and DateAdd()
0 new messages