Kettle reads the data in the table Oracle can't read, but in PLSQL can check out
Perform a table input will not complain, but read the data of 0
In PLSQL query data is can check out
In a computer is also the result of the same

CodePudding user response:

Select
SignDate,
Min (signTime) as signTime,
SignType,
Tel
The from (
The select EMPLOYEENO,
Substr (checktime, 0, 10) as signDate,
Substr (checktime, 12, 9) as signTime,
In case the APM
When the 'AM' then 1
When the 'PM' then 2
End as signType,
Tel
The from (
The select EMPLOYEENO,
To_char (cast (cast (checktime as timestamp) as the date), '- dd yyyy - mm hh24: mi: ss') as checktime,
To_char (substr (checktime, 27, 2)) APM,
Substr (MOBILE, 4, 11) tel
The from TH_FS_ATTENDANCE_RECORD
))
Where signType=1
And signDate=to_char (SYSDATE, 'YYYY - MM - DD)
Group by tel, signDate, signType



SQL will use this is because the TIMESTAMP format TIMESTAMP field.

CodePudding user response:

The TIMESTAMP format TIMESTAMP will generate such a data field
26 - APR - 20 05.01.59.000000 PM
This field is display in different compilers is different also

CodePudding user response:

As a try in kettle, look at that in addition to the problem?

CodePudding user response:

reference hdy1989 reply: 3/f

as a try in kettle, see a problem with that?

Is the problem that the timestamp format, PLSQL display is 26 - APR - 20 05.01.59.000000 PM the timestamp format, inside the kettle parsing into another format, so I gave a timestamp conversion with an item, and then an error, replace the timestamp type with varchar2 or date type conversion was no problem again