Conversion from Number to Date

[M Sarwar <sarwarmd02@xxxxxxxxxxx>]

 

Hello,

 

Environment:

                                AWS / RDS

                                Postgres 13.7

 

Column formats:

                                START_TIME CHARACTER VARYING(20) COLLATE PG_CATALOG."DEFAULT",

                                STOP_TIME CHARACTER VARYING(20) COLLATE PG_CATALOG."DEFAULT",

SQL:-

select

                TEST_PART_DET_ALL_MCM_ID,

                START_TIME, STOP_TIME,

                START_TIME::numeric (20, 11), STOP_TIME::numeric (20, 11)

from BRONX.TEST_PART_DETAILS_ALL_MCM

limit 3

;

 

Output:

478         "44795.7306776851"       "44795.731708"                 44795.73067768510         44795.73170800000

479         "44795.58143"                   "44795.58246"                   44795.58143000000         44795.58246000000

480         "44795.5714184259"       "44795.572495"                 44795.57141842590         44795.57249500000

 

During the data load from CSV files to the database, the above START_TIME and STOP_TIME date column data arrived as number value.

Now I need  to translate the START_TIME and STOP_TIME back to DATE format.

I am unable to find any documentation or help from the internet.

 

Does it make sense or did I mess up something?

Thanks,

Sarwar

Working late night of EST