Search code examples
pythonamazon-redshiftparquet

What is difference between timestamp[ns] timestamp[s]?

I am reading the schema of parquet and JSON files to generate a DDL for a redshift table. I am getting some data types like timestamp[ns] and timestamp[s]. I tried to look upon the internet but couldn't understand the difference. Can you please make me understand with some examples?

Solution

  • timestamp[x] is expressed in units x.

    For you, s=seconds, ns=nanoseconds

    For example:

    Timestamp[s] = 2020-03-14T15:32:52

    Timestamp[ms] = 2020-03-14T15:32:52.192

    Timestamp[us] = 2020-03-14T15:32:52.192548

    Timestamo[ns]= 2020-03-14T15:32:52.192548165