A valid MySQL date would be YYYY-MM-DD, so to convert your string into that use - select str_to_date('10-oct-2006', "%d-%b-%Y");
In order to get a date formtted DD-MM-YYYY you use
- select date_format(str_to_date('10-oct-2006', "%d-%b-%Y"), "%d-%m-%Y");
Anyway, it is all in the MySQL manual!
Ronald :cool:
Thankyou but this already done
i want to call the field at the date place.
select date_format(str _to_date('11-oct-2006', "%d-%b-%Y"), "%d-%m-%Y");
+-----------------------------------------------------------------+
| date_format(str _to_date('10-oct-2006', "%d-%b-%Y"), "%d-%m-%Y") |
+-----------------------------------------------------------------+
| 10-10-2006 |
+-----------------------------------------------------------------+
In mytable i insert the date at use_date.
create table sample(name varchar(20),use _date varchar(16));
insert into sample values('java',' 11-oct-2006');
select name,date_forma t(str_to_date(' use_date', "%d-%b-%Y"), "%d-%m-%Y") from sample;
but it gives the output like this
+------+--------------------------------------------------------------+
| name | date_format(str _to_date('use_d ate', "%d-%b-%Y"), "%d-%m-%Y") |
+------+--------------------------------------------------------------+
| java | |
+------+--------------------------------------------------------------+
how to overcome this pls help
Thanks
Sang