SQL

how to find date from date table in sql

SELECT CONVERT(date, getdate());

how to search date in sql query

 select * from test 
 where date between '03/19/2014' and '03/19/2014 23:59:59'

how to search date in sql query

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

sql date time query find

select convert(VARCHAR(40),create_date,121) , * from sys.objects where     convert(VARCHAR(40),create_date,121) LIKE '%17:34%'