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
    20120-04-01 00:00:00

I am not able to figure out where is the problem because 99% of the rows are having proper timestamp for this column.

Leave a Reply

Your email address will not be published. Required fields are marked *