- My View
Is the issue related to one table or for all the table's record?
PS: Your feedback (Like, Helpful or Correct) helps community
have you imported the data into the table? it generally happens due to the invalid date entry.
is this happening on your PDI or org. instance.
Hit correct/helpful based on impact.
This is happening in all the tables everywhere wherever date/time field is there
Check your System Properties > Properties. Look at your Date format and your time format. By default they should be:
Date format: yyyy-MM-dd
Time format: HH:mm:ss
If you are Importing data then check the format of date and time in importing file and format of fields in table whether same or not. If not change the date and time format of fields in table. It will work.