I have a text file which is extracted from a non-sql
database each night and then a cron sql script runs to
insert the text data into the mysql database tables.
My problem is that the date data in the text file is
formatted incosistently (12/31/00 or 12-31-00) and so
the fields that hold date data are currently char
datatypes.
Since I need the dates to be dates for queries, I need
a solution which will allow me to insert the date data
into the database as a date field datatype.
I'm sure some type of script could be written to
reformat the dates so they could be inserted as dates,
but I don't have the knowledge of any scripting
language to do this. If anyone has accomplished this
task or can point me in the right direction to solve
this problem, I would appreciate it.
Darla
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
