How to get date from datetime in sql?

Question

I have this datetime colums:

no     datetime
1     2021-03-26 19:31:38
2     2021-03-26 19:34:33
3     2021-03-26 19:40:21

and I want convert the datetime to get the date only and put it in a new column. The expected table is:

no     datetime                  date
1     2021-03-26 19:31:38      2021-03-26
2     2021-03-26 19:34:33      2021-03-26
3     2021-03-26 19:40:21      2021-03-26

How can I make it with sql query?

Thanks in advance