inserting date/time from text file.

[webgeo99]

Hi all. I have a text file I'm inserting into my mysql database. However, the text file contains a datetime field.
I'm using phpMyAdmin to speed up the process. is there a
way that I can set up the insertion of the file to contain
the date and time as it appears in the text file? Right
now when I insert the data, all I'm getting is zeros.
I know it's possible from the command line. However, I do
not have access to the command line on the production server.

 

[azzazzello]

perhaps it is not in format that Mysql recognizes as datetime. What is the format of the field in the text file?