Hello All,
I want to convert the string '18 October 2002' to the date format
'2002-10-18' using MySQL.
Essentially this is the reverse of the DATE_FORMAT(date,format) function.
I'm pretty sure it can't be done but does anyone out there have any ideas?
Thanks,
Andrew
sql,query
---
On 3 Oct 2002, at 15:33, Mark Colvin wrote:
> The problem I am having is with the DATE_FORMAT. Running the above query
> returns the following for the width column.
>
> 94.40 DATE_FORMAT(d1.created, '%d-%m-%Y'): NULL DATE_FORMAT(d1.amended,
> '%d-%m-%Y'): 03-10-2002
Show your PHP code. How ex
I run the following query from a php script -
select d1.code, d1.type, d1.descr, d1.grouptype, d1.cusref, d1.stock,
d1.minstock, d1.appmeth, d1.supplier, d1.suppref, d1.leadtime, d1.price,
d1.reorder, d1.code1, d1.code2, d1.notes, d1.usr, d1.usr, d1.cusname,
d1.colours, d1.stitchcount, d1.height,
