i have a date column which contains the date and time. i want to select only the date from the column how do i do it.
i enetered a select query as follows
select distinct left(regdate1,9) from user_details.
it was working fine but now it is not. please help me out.
cheers and thx in advance