RE: [PEAR] RE: [PHP] formatting sporadic date formats from access

Please disregard my last post as I cc'ed the wrong list :( -----Original Message----- From: Joseph Blythe [mailto:joseph@optcom.net.au] Sent: Friday, 9 May 2003 12:48 PM To: daniel@electroteque.org Cc: Pear-General (E-mail) Subject: [PEAR] RE: [PHP] formatting sporadic date formats from access This is hardly the list for access discussions but I will on this occasion finish the thread, you may contact me privately if you wish if you have any problems although as I was typing this the boss is on my back to finish a quote what's new though :) I will assume you have a copy of access 2000 1) open up the .mdb file and select the table you wish to export, on the "File menu choose export and choose text format (.csv) 2) The default options are fine on first page of the export wizard but you must go to the advanced options and adjust the date format options to mysql's default date format which is yyyy-mm-dd so: Date order = "YMD" Date delimiter = "-" 4 digit years = true Leading Zeros in dates = true I think that's about it finish the export and that should be okay to import into mySQL Hope this helps, Joseph -----Original Message----- From: daniel@electroteque.org [mailto:daniel@electroteque.org] Sent: Friday, 9 May 2003 12:10 PM To: joseph@optcom.net.au Subject: RE: [PHP] formatting sporadic date formats from access how can i do this ? > If you are importing via an export (csv for expample) from access I > found it easier to just format the exports date format to mysql's > format. > > Regards, > > Joseph > > -----Original Message----- > From: daniel@electroteque.org [mailto:daniel@electroteque.org] > Sent: Friday, 9 May 2003 11:32 AM > To: php-general@lists.php.net > Subject: [PHP] formatting sporadic date formats from access > > > hi guys i am trying to transform dodgy sporadic date formats from > access to a standard mysql form , here is an example of my headache > > Fri Jan 5 16:40 1996 > > what can i do to format this properly notice the year is at the end do > strtotime wont work :\ sometimes the year is in the right place > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PEAR General Mailing List (http://pear.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php