Thanks to Peter's hint here's an example of how I'll be doing it using PHP:
<?php
$date = "06-Sep-02 00:00:00";
$t = strftime("%Y-%m-%d %H:%M:%S", strtotime($date));
print "$t\n";
?>
David
> -----Original Message-----
> From: Peter Engstr�m [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 10, 2002 12:18 PM
> To: David Yee
> Cc: [EMAIL PROTECTED]
> Subject: Re: Convert dates for import into Mysql
>
>
> Hi David!
>
> What language do you use to build your application?
>
> You can do this easily with PHP.
> Please have a look at the following functions
> http://se.php.net/manual/en/function.strtotime.php
> http://se.php.net/manual/en/function.strftime.php
>
> Best regards
> /Peter
>
>
>
> ----- Original Message -----
> From: "David Yee" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, September 10, 2002 8:57 PM
> Subject: Convert dates for import into Mysql
>
>
> > Hi all. Does any one know how to convert dates like
> "06-Sep-02 00:00:00"
> > into the mysql datetime format? The main challenge here is probably
> > converting the 3 letter abbreviations for the month. Thanks for any
> input.
> >
> > David
> >
> >
> ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
