sslug-teknik team mailing list archive

[Martin Seebach <martin@xxxxxxxxxx>]

Den 27-10-2006 17:19, skrev Jesper K. Pedersen:
> Findes der nogen funktioner i MySQL der kan konvertere dette til en
> datetime type?

Sådan da..

mysql> select str_to_date("Oct/27/2006 16:40:50", "%M/%d/%Y %T");
+----------------------------------------------------+
| str_to_date("Oct/27/2006 16:40:50", "%M/%d/%Y %T") |
+----------------------------------------------------+
| 2006-10-27 16:40:50                                |
+----------------------------------------------------+
1 row in set (0.00 sec)

// Martin