sql query date now code example

Example 1: sql display today's date

SELECT getdate()

Example 2: how to search date in sql query

select * from test 
 where datediff(day, date, '03/19/2014') = 0