how to separate date and time from same column sql

Question

I have a column named DateTime but i want to show only Date from column not the time here is my query to show Date and Time from table

select Feedback.DateTime from ctrData2.Feedback

So help me to separate from Date from DateTime column.

Does this answer your question? [How to cast DATETIME as a DATE in mysql?](https://stackoverflow.com/questions/1468807/how-to-cast-datetime-as-a-date-in-mysql) — Digvijay S, Jun 12 '20 at 05:44

score 2 · Accepted Answer · answered Jun 12 '20 at 05:44

2

try this -

select date(Feedback.DateTime) from ctrData2.Feedback;

answered Jun 12 '20 at 05:44

switch

score 0 · Answer 2 · answered Jun 12 '20 at 05:44

0

You can try

select YEAR(Feedback.DateTime)+"-"+MONTH(Feedback.DateTime)+"-"+DAYOFMONTH(Feedback.DateTime) 
from ctrData2.Feedback

OR

select date_format(Feedback.DateTime, '%Y %m %d') from ctrData2.Feedback

answered Jun 12 '20 at 05:44

belaassal

2 Answers2