Answers for "find date in sql"

SQL
1

how to search date in sql query

select * from test 
 where date between '03/19/2014' and '03/19/2014 23:59:59'
Posted by: Guest on May-08-2020
0

how to find date from date table in sql

SELECT CONVERT(date, getdate());
Posted by: Guest on April-16-2021
0

how to search date in sql query

select * from test 
 where datediff(day, date, '03/19/2014') = 0
Posted by: Guest on May-08-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language