What is the postgreSql equivalent of Oracle timestamp(6). Does postreSql support timestamp in nanose-CodePudding

How do I execute the following Query from Oracle in PostgreSql:

SELECT to_timestamp('20210603033632200995','yyyymmddhh24missFF6');

CodePudding user response：

PostgreSQL has the standard conforming data type timestamp.

Six decimal places are microseconds, and yes, PostgreSQL supports that. It does not support nanoseconds, which would be 9 decimal places.

CodePudding user response：

I derived at

SELECT to_timestamp('20210603033632200995','yyyymmddhh24missUS');

This worked in PostgresSql workbench. Can anyone else the verify this solution?