Re: Time'n Date trouble - format pain
| From: | Becoming Digital | Date: | Mon, 26 May 2003 12:21:46 +0000 |
| Subject: | Re: Time'n Date trouble - format pain | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-28047@lists.php.net to get a copy of this message | ||
I haven't a specific answer for you, but either of the following pages may be of
help.
http://www.mysql.com/doc/en/Date_and_time_functions.html
http://us2.php.net/manual/en/ref.datetime.php
Edward Dudlik
Becoming Digital
www.becomingdigital.com
----- Original Message -----
From: "Ben9000" <ben9000@gmx.net>
To: "PHP-DB" <php-db@lists.php.net>
Sent: Monday, 26 May, 2003 04:37
Subject: [PHP-DB] Time'n Date trouble - format pain
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hello!
As my nightmare comes true I have to input CSV files into a MySQL DB.
The Date(time) format can differ in 3 different ways:
- - MM/DD/YYYY e.g. 06/25/2002
- - DD/MM/YYYY e.g. 17/03/2003
... AND ...
- - "Sat, 19 Apr 2003 12:57:23 +0200" :(((
Do you have some hint for me how I can avoid a pain of explode()s and
endless parsing?
Thank you for your help!
enjoy your day
Ben :)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)
iD8DBQE+0dI/ROwluvOuI4ARAtexAJ94MJuXm9h/7rlUYY7fhAN6sW5ixwCaAj2E
ucKctswt8qZKonxSynGAxNY=
=U7H2
-----END PGP SIGNATURE-----
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php