getdate() returns current datetime value. ie: 2009-11-06 15:07:05.463
So if you want to select rows where a date column is anytime "today" then:
EDIT: That technique is usually better than converting the date to a varchar and then comparing that value to your datetime value because sql then needs to convert all the values to do the comparison.
answered Nov 06, 2009 at 05:07 PM
The ANSI Standard is CURRENT_DATE for the date or CURRENT_TIMESTAMP for date and time. Virtually all SQLs support this now. Do not use the old getdate() that SQL Server got from Sybase, who got it from UNIX.
answered Nov 07, 2009 at 04:35 PM