Are you in a Perl or in a Java project ?

Yes it's a perl project. Has anyboby met this problem? Do you think it comes from Excel or Talend?
Thanks

Nicolep

Can you show us an extract of the content of the exported data in your MySQL database? (select * from table) and also I would like to see the table schema (desc tablename) Can you also put a tLogRow just before the tMysqlOutput and show us what the "Run job" view shows?

Hi,
Thanks for the link but I already try this conversion function. It works very well for dates in which day or month number doesn't begin with "0" (11/12/2007 for example) but dates like 02/07/2007 can't be well converted because the first automatic perl conversion gives 7-2-07 and not 07-02-07. So the length of day and month is not always 2 and the function doesn't understand.. I hope you understand the problem.
I join a .doc file to explain you my process.

Thanks.

Nicolep

Hi,

This function should solve your problem :

sub myFmtDate {
    my ($datestring) = @_ ;

    my ( $day, $month, $year ) = ( $datestring =~ m/(\d{1,2})[- \/](\d{1,2})[- |\/](\d{2,4})/ );

    return sprintf("%02s-%02s-%04s", $month, $day, 2000 + $year);
    
}

myFmtDate('2-3-07') -> 03-02-2007
myFmtDate('02-03-07') -> 03-02-2007

But don't use it with dates prior to year 2000 !!!

Best Regards

You're right the purpose of [- | \/] is to match "-" or "/" and there is no need for "|". This expression matches "-", "/", and "|" but it's not what we want.

my ( $day, $month, $year ) = ( $datestring =~ m/(\d{1,2})[- \/](\d{1,2})[- \/](\d{2,4})/ );

matches "2/3/07" or "2-3-07"

and

my ( $day, $month, $year ) = ( $datestring =~ m/(\d{1,2})[- |\/](\d{1,2})[- |\/](\d{2,4})/ );

matches "2/3/07" or "2-3-07" or "2|3|07" which is a rather uncommon date format !