this question is not strictly php related, but i thought possibly someone on this list might have dealt with this type of problem before. i am exporting a database out of filemakerpro 5 as a comma delimited file, and importing the data into a mysql database most of the information transfer over ok, the one big problem i have is filemaker's date/time format. in the filemaker pro database, it looks like the timestamp is stored in the format: M/DD/YYYY mysql will not let me create a DATETIME field with X/XX/XXXX as the default value. it automatically changes the default value to '0000-00-00'. i will migrate the filemaker pro data, using VARCHAR 10 to store the timestamp information, but there needs to be a way to go through every entry in this column, convert a string such as 'M/DD/YYYY' to something compatible with mysql's DATETIME format. the reason i'd like to convert the filemaker-generated 'M/DD/YYYY' timestamp string, which would be stored as VARCHAR in the db - to something like '0000-00-00' - is that i'd like to convert the the data type of this field from varchar 10 to DATETIME with a default value of 0000-00-00, so that any sql queries searching through the database by date will be compatible, as will any future entries that get tacked onto this field in the database after the migration from filemaker, which will be in DATETIME format i don't know if this can be accomplished by php, or some other type of scripting language. i'd like to avoid having to manually edit the timestamp information if i can avoid it... if anyone has any suggestions, i'd really appreciate it thank you -- ______________________________________________ http://www.linuxmail.org/ Now with e-mail forwarding for only US$5.95/yr
Powered by Outblaze -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
