I want to seprate date and time from a column

[#1]

Hello all,

The problem here is I have a colum which is displaying data as

msg_rcpt_log

10-03-2013 10:21

17-07-2015 18:40

20-07-2015 17:30

20-07-2015 21:49

20-07-2015 21:57

Now I want to get the dates only so that whenever I click on that date I can get the analytics for that.

[#2]

First load your all date than use this exp date(timestamp#(time,'DD-MM-YYYY hh:mm'),'DD') as day1
in resident load