Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQL Date expressions

12 views
Skip to first unread message

contracer

unread,
Apr 17, 2013, 10:17:20 AM4/17/13
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 AM4/17/13
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