[wplug] Convert 6/16/2003 0:00:00 to 2003-06-16?
Weber, Larry A
laweber at switch.com
Tue Jan 13 13:44:07 EST 2004
Wait one. Are not .csv files a spread sheet file, open with Excel.
> -----Original Message-----
> From: Russ Schneider [SMTP:russ at sugapablo.com]
> Sent: Tuesday, January 13, 2004 1:29 PM
> To: WPLUG
> Subject: [wplug] Convert 6/16/2003 0:00:00 to 2003-06-16?
>
> I have a CSV someone gave me from MS Access.
>
> I need to import this into MySQL.
>
> But the dates read like 6/16/2003 0:00:00 and I need to convert them in
> the text file to a what MySQL expects, which is 2003-06-16.
>
> Anyone have any really good ideas?
>
>
> --
> [ Russ Schneider (a.k.a. Sugapablo) ]
> [ http://www.sugapablo.com <--music ]
> [ http://www.sugapablo.net <--personal ]
> [ sugapablo at 12jabber.com <--jabber IM ]
> _______________________________________________
> wplug mailing list
> wplug at wplug.org
> http://www.wplug.org/mailman/listinfo/wplug
More information about the wplug
mailing list