Home > Archive > Microsoft SQL Server forum > July 2005 > WHAT DO I USE TO MAKE A TODAY DATE QUERY









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author WHAT DO I USE TO MAKE A TODAY DATE QUERY
Fernand St-Georges

2005-07-21, 11:24 am

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

2005-07-22, 3:23 am

No - GETDATE() includes the time.

http://www.karaszi.com/sqlserver/in...e.asp#Searching

Simon

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com