hi there

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