WHAT DO I USE TO MAKE A TODAY DATE QUERY

[Fernand St-Georges]

select no_dossier from dbo.membre where date_MAJ = GETDATE()

select no_dossier from dbo.membre where date_MAJ = '2005-07-21'

Both should give me the same result, yes or no?

thanks

[Simon Hayes]

Re: WHAT DO I USE TO MAKE A TODAY DATE QUERY

No - GETDATE() includes the time.

http://www.karaszi.com/sqlserver/info_datetime.asp#Searching

Simon