hi,

i am doing a web based database project whose function is to retrieve and format data only in the web browser.

i suddenly came across this problem in loading a flat file to a database when i found out that the date and time are in different formats...
example:


* the date in file1 is mm/dd/yy and the time is hh:mm:ss
* the date and time in file2 are combined in one column dd/mm/yyyy_hh:mm:ss


both files are located in a single database, but different tables entierly independent of each other.

how will i be able to load this kind of flat file in a mysql database?

* i need to separate date and time because they will be shown in the web browser in a tabular form.

thanks...

Just use a regular expression in whatever programming language you use to rearrange the data.

i don't get it... isn't it that loading a text file uses the LOAD DATA command? i can't seem to understand where to put the regular expressions there...