I use kettle to transform date from SQL server datebase to another SQL server datebase,but when i solve the binary type ,error occurs,as follows.
1) The source table has columns which use binary(8) type,figure 1.
2) I read the date use native(JDBC),but the binary date can not show normal,figure 2.
3) I convert the binary date to int in SQL statement,it works fine.
4) Then i transform the int date to binary date,but error occurs,figure 3.
How can i solve this problem?
Thanks a lot.
Name:  表形式.jpg
Views: 46
Size:  23.3 KBName:  rowversion无法读取.PNG
Views: 45
Size:  14.8 KBName:  int转binary错误.jpg
Views: 40
Size:  40.8 KB