Fetch Data on current date

[ZABARVAN]

How can we fetch data from tabels meeting the current date critria.

Select * from table where ord.date = ??????? ( here I need help)

Will be much appreciated.

Thanking you

Zab

 

[imex]

In the 2008 version or higher try:

where DateColumn = CAST(GETDATE() as DATE)

In versions before 2008 try:

where DateColumn = CONVERT(VARCHAR(10), GETDATE(), 111)

Hope this helps.

[URL unfurl="true"]http://www.imoveisemexposicao.com.br/imoveis-venda-são_paulo-residencial-apartamento[/url]

 

[bborissov]

DECLARE @Today datetime
SET @Today = DATEADD(dd,0, DATEDIFF(dd, 0, GETDATE()))

SELECT ...
...
WHERE ord.date >= @Today AND
      ord.date <  @Today+1

Borislav Borissov
VFP9 SP2, SQL Server

 

[markros]

Take a look at this blog post
Bad habits to kick : mis-handling date / range queries

PluralSight Learning Library