Categories
Database Development

Column with timestamp datatype not having proper value

I am using PostgreSQL v9.5 A column utime with datatype timestamp without timezone is not having proper values for some rows as given below: select utime from mytable where utime is not null order by utime desc limit 10; 202020-02-12 00:00:00 25019-10-10 00:00:00 22019-09-20 00:00:00 22019-09-20 00:00:00 22019-09-20 00:00:00 22019-09-20 00:00:00 22019-09-10 00:00:00 20188-07-09 00:00:00 […]