NULL dates istead of 0000-00-00
authorDobrica Pavlinusic <dpavlin@rot13.org>
Wed, 15 Jun 2011 16:17:43 +0000 (18:17 +0200)
committerDobrica Pavlinusic <dpavlin@rot13.org>
Wed, 15 Jun 2011 16:17:43 +0000 (18:17 +0200)
ferlib2koha.pl

index a3abc3b..a2bfbbb 100755 (executable)
@@ -56,7 +56,7 @@ sub insert {
        );
 
        foreach my $c ( grep { /(date|timestamp)/ } keys %$row ) {
-               $row->{$c} =~ s/^(\d\d)\.(\d\d)\.(\d\d\d\d)/$3-$2-$1/;
+               $row->{$c} =~ s/^(\d\d)\.(\d\d)\.(\d\d\d\d)/$3-$2-$1/ or $row->{$c} = undef; # XXX NULL dates istead of 0000-00-00
        }
 
        $insert->{$table}->execute( values %$row );