emcp
09/30/2022, 5:13 PMYYYY-MM-DDThh-mm-SS.ssssssZ
This is because that is what my usual target postgresql wants... but NOW I am playing with trino and its integration with HIVE Metastore to use S3 as a datalake that I can query... and there the timestamp gets rejected unless I give it in MSfromepoch
format with a precision of 3 places removed ie 1663529000000000