I have checked the value without any formulas, and it returns a correct Unix Timestamp value (2nd screenshot), but when I try to parse it (without formating), it gives me this value (1st screenshot).
And when I add format, it gives me the value that I attached earlier.
Oh, are you inserting into Google sheets? Then you might just be able to format the entire column of cells as date format, directly in Google sheets itself.