Mysql 4, I have datetime field set of 0000-00-00 00:00:00

Sampling of data I need to insert in is as follow:
12/26/04 13:35
12/25/04 12:41
12/25/04 8:53

How do a massage that to the proper format YYY-MM-DD HH:MM:SS

thanks
-- 
-------------------------------------------------------------
Scott Haneda                                Tel: 415.898.2602
<http://www.newgeo.com>                     Fax: 313.557.5052
<[EMAIL PROTECTED]>                          Novato, CA U.S.A.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to