user2834828 user2834828 - 1 year ago 103
MySQL Question

Mysql function DATE() on sql server?

I need to convert this MYSQL query to sql server:


How can i translate this query on sql server language?


Answer Source

You can use either of the following ..

SELECT CONVERT(DATE,datetime_field)


 SELECT CAST (datetime_field as date)
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download