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: 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
