How to convert date Varchar Format to Date Format using sql query.In my project i need to search records by date.
that is from DateTime to to DateTime.my i am create the DateTime in Varchar format.
now i Search records using from and to DateTimeit is not show exact output.
i thing my created date format is wrong and that is the reason.
So i want to convert from date and to date from varchar datatype to DateTimeFormat.
and also which format will be give exact output for me is very important.
So please help me to how i am Convert already created data type Varchar to DateTime format
or may i drop the column and recreate a new column with DateTime Format.
i am having lot of stress with this module friends.