Conversion from Number to Date

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