Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

inserting date/time from text file.

Status
Not open for further replies.

webgeo99

Programmer
Apr 22, 2005
2
US
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.
 
perhaps it is not in format that Mysql recognizes as datetime. What is the format of the field in the text file?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top