Examples 55–66 · Part II: Data Definition and Types
| # | Example | Level |
|---|---|---|
| 55 | The four date and time types | Beginner |
| 56 | timestamptz stores an instant, not a zone | Beginner |
| 57 | AT TIME ZONE converts in both directions | Intermediate |
| 58 | Plain timestamp is ambiguous | Intermediate |
| 59 | now, current_timestamp and clock_timestamp | Beginner |
| 60 | now() is frozen for the whole transaction | Intermediate |
| 61 | Date and time literals and input formats | Beginner |
| 62 | Daylight saving time: a day is not always 24 hours | Advanced |
| 63 | When plain timestamp is the right choice | Intermediate |
| 64 | Extracting a part versus truncating | Beginner |
| 65 | Build and decompose intervals | Intermediate |
| 66 | Choosing date and time types for a schema | Advanced |
The solutions and explanations are in the book.