How to query date where datetime data ?

Yii 1.1 General Discussion
1

id name createdate

1 A 2016-03-01 20:02:44

2 B 2016-03-02 16:10:45

3 C 2016-03-02 14:03:01

SELECT * FROM level WHERE createdate = ‘2016-03-02’

why data can not show ?? so data there are 2

2

SELECT * FROM level WHERE DATE(createdate) = ‘2016-03-02’

3

My application running 3 database. in MySQL so running well. How to query in SQL Server ?? :D