ericfe
diff --git a/‎sqlserver2pgsql.pl‎
Lines changed: 4 additions & 4 deletions b/‎sqlserver2pgsql.pl‎
Lines changed: 4 additions & 4 deletions
@@ -140,7 +140,7 @@ sub convert_numeric_to_int
 }
 
 # This is a list of the types that require a cast to be imported in kettle
-my %types_to_cast = ('uuid'  => '1',);
+my %types_to_cast = ('uuid'  => '1','date'  => '1');
 
 # This sub adds a cast (if not defined already) if
 # - we generate for kettle
@@ -150,7 +150,7 @@ sub add_cast
     my ($type)=@_;
     if (defined $types_to_cast{$type})
     {
-        $objects->{CASTS}->{uuid}=1;
+        $objects->{CASTS}->{$type}=1;
     }
 }
 
@@ -327,10 +327,10 @@ sub convert_type
 sub sql_convert_column
 {
     my ($colname,$coltype)=@_;
-    my %functions = ( 'uuid' => 'lower');
+    my %functions = ( 'uuid' => 'lower({colname})', 'date' => 'convert(varchar, {colname}, 120)' );
     if (defined ($functions{$coltype}))
     {
-        return $functions{$coltype} . '([' . $colname . '])';
+		return $functions{$coltype} =~ s/\{colname\}/[$colname]/r;
     }
     else
     {
Original file line number	Diff line number	Diff line change
`@@ -140,7 +140,7 @@ sub convert_numeric_to_int`
`140`	`140`	`}`
`141`	`141`
`142`	`142`	`# This is a list of the types that require a cast to be imported in kettle`
`143`		`-my %types_to_cast = ('uuid' => '1',);`
	`143`	`+my %types_to_cast = ('uuid' => '1','date' => '1');`
`144`	`144`
`145`	`145`	`# This sub adds a cast (if not defined already) if`
`146`	`146`	`# - we generate for kettle`
`@@ -150,7 +150,7 @@ sub add_cast`
`150`	`150`	`my ($type)=@_;`
`151`	`151`	`if (defined $types_to_cast{$type})`
`152`	`152`	`{`
`153`		`- $objects->{CASTS}->{uuid}=1;`
	`153`	`+ $objects->{CASTS}->{$type}=1;`
`154`	`154`	`}`
`155`	`155`	`}`
`156`	`156`
`@@ -327,10 +327,10 @@ sub convert_type`
`327`	`327`	`sub sql_convert_column`
`328`	`328`	`{`
`329`	`329`	`my ($colname,$coltype)=@_;`
`330`		`- my %functions = ( 'uuid' => 'lower');`
	`330`	`+ my %functions = ( 'uuid' => 'lower({colname})', 'date' => 'convert(varchar, {colname}, 120)' );`
`331`	`331`	`if (defined ($functions{$coltype}))`
`332`	`332`	`{`
`333`		`- return $functions{$coltype} . '([' . $colname . '])';`
	`333`	`+ return $functions{$coltype} =~ s/\{colname\}/[$colname]/r;`
`334`	`334`	`}`
`335`	`335`	`else`
`336`	`336`	`{`