[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