Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1449

Re: SQL Date expressions

Newsgroups comp.databases.ms-sqlserver
Date 2013-04-17 07:50 -0700
References <03f8c0f4-4009-4762-8337-aeb7d15a926a@googlegroups.com>
Message-ID <0fa01ee9-58f2-4d47-b9eb-78212b694d8b@googlegroups.com> (permalink)
Subject Re: SQL Date expressions
From bradbury9 <ray.bradbury9@gmail.com>

Show all headers | View raw

El miércoles, 17 de abril de 2013 16:17:20 UTC+2, contracer  escribió:
> Hi, 
> 
> 
> 
> How could I create these sql expressions ?
> 
> 
> 
> last 7 days
> 
> last 30 days
> 
> last month
> 
> last week
> 
> this year
> 
> last year
> 
> 
> 
> Thanks

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()

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

SQL Date expressions contracer <contracer11@gmail.com> - 2013-04-17 07:17 -0700
  Re: SQL Date expressions bradbury9 <ray.bradbury9@gmail.com> - 2013-04-17 07:50 -0700

csiph-web