php strtotime() Re: [wplug] Convert 6/16/2003 0:00:00 to 2003-06-16?

Patryk Laurent patryk at pakl.net
Tue Jan 13 13:42:36 EST 2004


Can you use php?  If so, check out the strtotime() function. You could use 
it along with date().
      
Patryk                                                                   
       
                                                                         
       

On Tue, 13 Jan 2004, Russ Schneider wrote:

> Date: Tue, 13 Jan 2004 13:28:41 -0500 (EST)
> From: Russ Schneider <russ at sugapablo.com>
> Reply-To: wplug at wplug.org
> To: WPLUG <wplug at wplug.org>
> 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?
> 
> 
> 




More information about the wplug mailing list