Re: load data --- problem with date format ---
Yes I am running apache, PHP and MySQL on Win2K server. The TXT file is a report made by another WIN32 application. I solved the problem with temporary field and mysql query. Excel was just a temporary solution for transforming date format.
At this point i am facing another problem. The values that i get in TXT have decimals separated by (,)( 1550,80€ ) and by loading data in mysql the numbers behind coma are lost. Imported value changes to 1550.00€ The field importing to is set to DECIMAL(15,2)
Thank you for help
Subject
Views
Written By
Posted
8601
September 20, 2004 07:11AM
3507
September 21, 2004 12:46AM
Re: load data --- problem with date format ---
4019
September 21, 2004 01:15AM
3126
September 21, 2004 01:45AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.