Search code examples
postgresqltimestampsqldatatypestimestamp-with-timezone

What is the Significance of timestamps with/without time zone in PostgreSQL and when to use them?

I need to save a current location of a car in an app which operates only in USA and I'm confused with datatype of psql between TIMESTAMP WITH TIMEZONE and TIMESTAMP WITHOUT TIME ZONE. Can the differences be explained ?

Solution

  • The difference is

    • The storage of TIME or TIMESTAMP differs between one WITH TIME ZONE or WITHOUT TIME ZONE

    • With a time zone as part of the value , the value could be local time in the client side

    • Without a time zone , value will be UTC Time by default .

    So by default it will be saved in UTC , You can convert into specific time zones .