[wplug] Convert 6/16/2003 0:00:00 to 2003-06-16?

[Weber, Larry A]

Use Access to export the file to .txt.  You will get a space(might be tab)
delimited set of quoted entries for each record.  You should be able to
reformat with a text editor.

> -----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