Hey guys, this is my first post! yippie.
Anway, I am working in mysql using mysql-front as my GUI under winNT and I am trying to import a text file to populate my database.
The textfile has the date formatted as 'MM/DD/YYYY' so I have been using the date field as type=text rather than date. But I would now like to use the actual date so I can search for date ranges, etc.
My question is, does date_format actually change the way mySQL will want the imported text file date values or is that just for use in select statements? How can I workaround this without modifying my text file?
thx in adv.
dave
Anway, I am working in mysql using mysql-front as my GUI under winNT and I am trying to import a text file to populate my database.
The textfile has the date formatted as 'MM/DD/YYYY' so I have been using the date field as type=text rather than date. But I would now like to use the actual date so I can search for date ranges, etc.
My question is, does date_format actually change the way mySQL will want the imported text file date values or is that just for use in select statements? How can I workaround this without modifying my text file?
thx in adv.
dave