Databases · Junior · Question 40 of 75

Which type should you usually use for timestamps in PostgreSQL?

Explanation

timestamptz stores an absolute moment (in UTC) and converts to the session time zone on output. Plain timestamp has no zone, so its meaning is ambiguous.

Further reading

Problem with a question

Databases · Junior · question 40

Test yourself

Take the Databases · Junior quiz: questions and options are shuffled, and you get a review of your mistakes at the end.

Take this quiz