PostgreSQL Source Code git master
Loading...
Searching...
No Matches
Data Structures | Macros | Typedefs
timestamp.h File Reference
This graph shows which files directly or indirectly include this file:

Go to the source code of this file.

Data Structures

struct  Interval
 
struct  pg_itm
 
struct  pg_itm_in
 

Macros

#define MAX_TIMESTAMP_PRECISION   6
 
#define MAX_INTERVAL_PRECISION   6
 
#define TS_PREC_INV   1000000.0
 
#define TSROUND(j)   (rint(((double) (j)) * TS_PREC_INV) / TS_PREC_INV)
 
#define DAYS_PER_YEAR   365.25 /* assumes leap year every four years */
 
#define MONTHS_PER_YEAR   12
 
#define DAYS_PER_MONTH   30 /* assumes exactly 30 days per month */
 
#define DAYS_PER_WEEK   7
 
#define HOURS_PER_DAY   24 /* assume no daylight savings time changes */
 
#define SECS_PER_YEAR   (36525 * 864) /* avoid floating-point computation */
 
#define SECS_PER_DAY   86400
 
#define SECS_PER_HOUR   3600
 
#define SECS_PER_MINUTE   60
 
#define MINS_PER_HOUR   60
 
#define USECS_PER_DAY   INT64CONST(86400000000)
 
#define USECS_PER_HOUR   INT64CONST(3600000000)
 
#define USECS_PER_MINUTE   INT64CONST(60000000)
 
#define USECS_PER_SEC   INT64CONST(1000000)
 
#define MAX_TZDISP_HOUR   15 /* maximum allowed hour part */
 
#define TZDISP_LIMIT   ((MAX_TZDISP_HOUR + 1) * SECS_PER_HOUR)
 
#define TIMESTAMP_MINUS_INFINITY   PG_INT64_MIN
 
#define TIMESTAMP_INFINITY   PG_INT64_MAX
 
#define DT_NOBEGIN   TIMESTAMP_MINUS_INFINITY
 
#define DT_NOEND   TIMESTAMP_INFINITY
 
#define TIMESTAMP_NOBEGIN(j)    do {(j) = DT_NOBEGIN;} while (0)
 
#define TIMESTAMP_IS_NOBEGIN(j)   ((j) == DT_NOBEGIN)
 
#define TIMESTAMP_NOEND(j)    do {(j) = DT_NOEND;} while (0)
 
#define TIMESTAMP_IS_NOEND(j)   ((j) == DT_NOEND)
 
#define TIMESTAMP_NOT_FINITE(j)   (TIMESTAMP_IS_NOBEGIN(j) || TIMESTAMP_IS_NOEND(j))
 
#define INTERVAL_NOBEGIN(i)
 
#define INTERVAL_IS_NOBEGIN(i)    ((i)->month == PG_INT32_MIN && (i)->day == PG_INT32_MIN && (i)->time == PG_INT64_MIN)
 
#define INTERVAL_NOEND(i)
 
#define INTERVAL_IS_NOEND(i)    ((i)->month == PG_INT32_MAX && (i)->day == PG_INT32_MAX && (i)->time == PG_INT64_MAX)
 
#define INTERVAL_NOT_FINITE(i)   (INTERVAL_IS_NOBEGIN(i) || INTERVAL_IS_NOEND(i))
 
#define JULIAN_MINYEAR   (-4713)
 
#define JULIAN_MINMONTH   (11)
 
#define JULIAN_MINDAY   (24)
 
#define JULIAN_MAXYEAR   (5874898)
 
#define JULIAN_MAXMONTH   (6)
 
#define JULIAN_MAXDAY   (3)
 
#define IS_VALID_JULIAN(y, m, d)
 
#define UNIX_EPOCH_JDATE   2440588 /* == date2j(1970, 1, 1) */
 
#define POSTGRES_EPOCH_JDATE   2451545 /* == date2j(2000, 1, 1) */
 
#define DATETIME_MIN_JULIAN   (0)
 
#define DATE_END_JULIAN   (2147483494) /* == date2j(JULIAN_MAXYEAR, 1, 1) */
 
#define TIMESTAMP_END_JULIAN   (109203528) /* == date2j(294277, 1, 1) */
 
#define MIN_TIMESTAMP   INT64CONST(-211813488000000000)
 
#define END_TIMESTAMP   INT64CONST(9223371331200000000)
 
#define IS_VALID_DATE(d)
 
#define IS_VALID_TIMESTAMP(t)   (MIN_TIMESTAMP <= (t) && (t) < END_TIMESTAMP)
 

Typedefs

typedef int64 Timestamp
 
typedef int64 TimestampTz
 
typedef int64 TimeOffset
 
typedef int32 fsec_t
 

Macro Definition Documentation

◆ DATE_END_JULIAN

#define DATE_END_JULIAN   (2147483494) /* == date2j(JULIAN_MAXYEAR, 1, 1) */

Definition at line 252 of file timestamp.h.

◆ DATETIME_MIN_JULIAN

#define DATETIME_MIN_JULIAN   (0)

Definition at line 251 of file timestamp.h.

◆ DAYS_PER_MONTH

#define DAYS_PER_MONTH   30 /* assumes exactly 30 days per month */

Definition at line 116 of file timestamp.h.

◆ DAYS_PER_WEEK

#define DAYS_PER_WEEK   7

Definition at line 117 of file timestamp.h.

◆ DAYS_PER_YEAR

#define DAYS_PER_YEAR   365.25 /* assumes leap year every four years */

Definition at line 107 of file timestamp.h.

◆ DT_NOBEGIN

#define DT_NOBEGIN   TIMESTAMP_MINUS_INFINITY

Definition at line 156 of file timestamp.h.

◆ DT_NOEND

#define DT_NOEND   TIMESTAMP_INFINITY

Definition at line 157 of file timestamp.h.

◆ END_TIMESTAMP

#define END_TIMESTAMP   INT64CONST(9223371331200000000)

Definition at line 258 of file timestamp.h.

◆ HOURS_PER_DAY

#define HOURS_PER_DAY   24 /* assume no daylight savings time changes */

Definition at line 118 of file timestamp.h.

◆ INTERVAL_IS_NOBEGIN

#define INTERVAL_IS_NOBEGIN (   i)     ((i)->month == PG_INT32_MIN && (i)->day == PG_INT32_MIN && (i)->time == PG_INT64_MIN)

Definition at line 182 of file timestamp.h.

185 { \
186 (i)->time = PG_INT64_MAX; \
187 (i)->day = PG_INT32_MAX; \
188 (i)->month = PG_INT32_MAX; \
189 } while (0)
190
191#define INTERVAL_IS_NOEND(i) \
192 ((i)->month == PG_INT32_MAX && (i)->day == PG_INT32_MAX && (i)->time == PG_INT64_MAX)
193
194#define INTERVAL_NOT_FINITE(i) (INTERVAL_IS_NOBEGIN(i) || INTERVAL_IS_NOEND(i))
195
196/*
197 * Julian date support.
198 *
199 * date2j() and j2date() nominally handle the Julian date range 0..INT_MAX,
200 * or 4714-11-24 BC to 5874898-06-03 AD. In practice, date2j() will work and
201 * give correct negative Julian dates for dates before 4714-11-24 BC as well.
202 * We rely on it to do so back to 4714-11-01 BC. Allowing at least one day's
203 * slop is necessary so that timestamp rotation doesn't produce dates that
204 * would be rejected on input. For example, '4714-11-24 00:00 GMT BC' is a
205 * legal timestamptz value, but in zones east of Greenwich it would print as
206 * sometime in the afternoon of 4714-11-23 BC; if we couldn't process such a
207 * date we'd have a dump/reload failure. So the idea is for IS_VALID_JULIAN
208 * to accept a slightly wider range of dates than we really support, and
209 * then we apply the exact checks in IS_VALID_DATE or IS_VALID_TIMESTAMP,
210 * after timezone rotation if any. To save a few cycles, we can make
211 * IS_VALID_JULIAN check only to the month boundary, since its exact cutoffs
212 * are not very critical in this scheme.
213 *
214 * It is correct that JULIAN_MINYEAR is -4713, not -4714; it is defined to
215 * allow easy comparison to tm_year values, in which we follow the convention
216 * that tm_year <= 0 represents abs(tm_year)+1 BC.
217 */
218
219#define JULIAN_MINYEAR (-4713)
220#define JULIAN_MINMONTH (11)
221#define JULIAN_MINDAY (24)
222#define JULIAN_MAXYEAR (5874898)
223#define JULIAN_MAXMONTH (6)
224#define JULIAN_MAXDAY (3)
225
226#define IS_VALID_JULIAN(y,m,d) \
227 (((y) > JULIAN_MINYEAR || \
228 ((y) == JULIAN_MINYEAR && ((m) >= JULIAN_MINMONTH))) && \
229 ((y) < JULIAN_MAXYEAR || \
230 ((y) == JULIAN_MAXYEAR && ((m) < JULIAN_MAXMONTH))))
231
232/* Julian-date equivalents of Day 0 in Unix and Postgres reckoning */
233#define UNIX_EPOCH_JDATE 2440588 /* == date2j(1970, 1, 1) */
234#define POSTGRES_EPOCH_JDATE 2451545 /* == date2j(2000, 1, 1) */
235
236/*
237 * Range limits for dates and timestamps.
238 *
239 * We have traditionally allowed Julian day zero as a valid datetime value,
240 * so that is the lower bound for both dates and timestamps.
241 *
242 * The upper limit for dates is 5874897-12-31, which is a bit less than what
243 * the Julian-date code can allow. For timestamps, the upper limit is
244 * 294276-12-31. The int64 overflow limit would be a few days later; again,
245 * leaving some slop avoids worries about corner-case overflow, and provides
246 * a simpler user-visible definition.
247 */
248
249/* First allowed date, and first disallowed date, in Julian-date form */
250#define DATETIME_MIN_JULIAN (0)
251#define DATE_END_JULIAN (2147483494) /* == date2j(JULIAN_MAXYEAR, 1, 1) */
252#define TIMESTAMP_END_JULIAN (109203528) /* == date2j(294277, 1, 1) */
253
254/* Timestamp limits */
255#define MIN_TIMESTAMP INT64CONST(-211813488000000000)
256/* == (DATETIME_MIN_JULIAN - POSTGRES_EPOCH_JDATE) * USECS_PER_DAY */
257#define END_TIMESTAMP INT64CONST(9223371331200000000)
258/* == (TIMESTAMP_END_JULIAN - POSTGRES_EPOCH_JDATE) * USECS_PER_DAY */
259
260/* Range-check a date (given in Postgres, not Julian, numbering) */
261#define IS_VALID_DATE(d) \
262 ((DATETIME_MIN_JULIAN - POSTGRES_EPOCH_JDATE) <= (d) && \
263 (d) < (DATE_END_JULIAN - POSTGRES_EPOCH_JDATE))
264
265/* Range-check a timestamp */
266#define IS_VALID_TIMESTAMP(t) (MIN_TIMESTAMP <= (t) && (t) < END_TIMESTAMP)
267
268#endif /* DATATYPE_TIMESTAMP_H */
PG_INT32_MAX
#define PG_INT32_MAX
Definition c.h:603
PG_INT64_MAX
#define PG_INT64_MAX
Definition c.h:606
i
int i
Definition isn.c:77

◆ INTERVAL_IS_NOEND

#define INTERVAL_IS_NOEND (   i)     ((i)->month == PG_INT32_MAX && (i)->day == PG_INT32_MAX && (i)->time == PG_INT64_MAX)

Definition at line 192 of file timestamp.h.

◆ INTERVAL_NOBEGIN

#define INTERVAL_NOBEGIN (   i)
Value:
do { \
(i)->time = PG_INT64_MIN; \
(i)->day = PG_INT32_MIN; \
(i)->month = PG_INT32_MIN; \
} while (0)
PG_INT64_MIN
#define PG_INT64_MIN
Definition c.h:605
PG_INT32_MIN
#define PG_INT32_MIN
Definition c.h:602

Definition at line 175 of file timestamp.h.

176 { \
177 (i)->time = PG_INT64_MIN; \
178 (i)->day = PG_INT32_MIN; \
179 (i)->month = PG_INT32_MIN; \
180 } while (0)

◆ INTERVAL_NOEND

#define INTERVAL_NOEND (   i)
Value:
do { \
(i)->time = PG_INT64_MAX; \
(i)->day = PG_INT32_MAX; \
(i)->month = PG_INT32_MAX; \
} while (0)

Definition at line 185 of file timestamp.h.

186 { \
187 (i)->time = PG_INT64_MAX; \
188 (i)->day = PG_INT32_MAX; \
189 (i)->month = PG_INT32_MAX; \
190 } while (0)

◆ INTERVAL_NOT_FINITE

#define INTERVAL_NOT_FINITE (   i)    (INTERVAL_IS_NOBEGIN(i) || INTERVAL_IS_NOEND(i))

Definition at line 195 of file timestamp.h.

◆ IS_VALID_DATE

#define IS_VALID_DATE (   d)
Value:
((DATETIME_MIN_JULIAN - POSTGRES_EPOCH_JDATE) <= (d) && \
(d) < (DATE_END_JULIAN - POSTGRES_EPOCH_JDATE))
DATETIME_MIN_JULIAN
#define DATETIME_MIN_JULIAN
Definition timestamp.h:251
DATE_END_JULIAN
#define DATE_END_JULIAN
Definition timestamp.h:252
POSTGRES_EPOCH_JDATE
#define POSTGRES_EPOCH_JDATE
Definition timestamp.h:235

Definition at line 262 of file timestamp.h.

◆ IS_VALID_JULIAN

#define IS_VALID_JULIAN (   y,
  m,
  d 
)
Value:
(((y) > JULIAN_MINYEAR || \
((y) == JULIAN_MINYEAR && ((m) >= JULIAN_MINMONTH))) && \
((y) < JULIAN_MAXYEAR || \
((y) == JULIAN_MAXYEAR && ((m) < JULIAN_MAXMONTH))))
JULIAN_MAXMONTH
#define JULIAN_MAXMONTH
Definition timestamp.h:224
JULIAN_MAXYEAR
#define JULIAN_MAXYEAR
Definition timestamp.h:223
JULIAN_MINMONTH
#define JULIAN_MINMONTH
Definition timestamp.h:221
JULIAN_MINYEAR
#define JULIAN_MINYEAR
Definition timestamp.h:220
y
int y
Definition isn.c:76

Definition at line 227 of file timestamp.h.

◆ IS_VALID_TIMESTAMP

#define IS_VALID_TIMESTAMP (   t)    (MIN_TIMESTAMP <= (t) && (t) < END_TIMESTAMP)

Definition at line 267 of file timestamp.h.

◆ JULIAN_MAXDAY

#define JULIAN_MAXDAY   (3)

Definition at line 225 of file timestamp.h.

◆ JULIAN_MAXMONTH

#define JULIAN_MAXMONTH   (6)

Definition at line 224 of file timestamp.h.

◆ JULIAN_MAXYEAR

#define JULIAN_MAXYEAR   (5874898)

Definition at line 223 of file timestamp.h.

◆ JULIAN_MINDAY

#define JULIAN_MINDAY   (24)

Definition at line 222 of file timestamp.h.

◆ JULIAN_MINMONTH

#define JULIAN_MINMONTH   (11)

Definition at line 221 of file timestamp.h.

◆ JULIAN_MINYEAR

#define JULIAN_MINYEAR   (-4713)

Definition at line 220 of file timestamp.h.

◆ MAX_INTERVAL_PRECISION

#define MAX_INTERVAL_PRECISION   6

Definition at line 93 of file timestamp.h.

◆ MAX_TIMESTAMP_PRECISION

#define MAX_TIMESTAMP_PRECISION   6

Definition at line 92 of file timestamp.h.

◆ MAX_TZDISP_HOUR

#define MAX_TZDISP_HOUR   15 /* maximum allowed hour part */

Definition at line 143 of file timestamp.h.

◆ MIN_TIMESTAMP

#define MIN_TIMESTAMP   INT64CONST(-211813488000000000)

Definition at line 256 of file timestamp.h.

◆ MINS_PER_HOUR

#define MINS_PER_HOUR   60

Definition at line 129 of file timestamp.h.

◆ MONTHS_PER_YEAR

#define MONTHS_PER_YEAR   12

Definition at line 108 of file timestamp.h.

◆ POSTGRES_EPOCH_JDATE

#define POSTGRES_EPOCH_JDATE   2451545 /* == date2j(2000, 1, 1) */

Definition at line 235 of file timestamp.h.

◆ SECS_PER_DAY

#define SECS_PER_DAY   86400

Definition at line 126 of file timestamp.h.

◆ SECS_PER_HOUR

#define SECS_PER_HOUR   3600

Definition at line 127 of file timestamp.h.

◆ SECS_PER_MINUTE

#define SECS_PER_MINUTE   60

Definition at line 128 of file timestamp.h.

◆ SECS_PER_YEAR

#define SECS_PER_YEAR   (36525 * 864) /* avoid floating-point computation */

Definition at line 125 of file timestamp.h.

◆ TIMESTAMP_END_JULIAN

#define TIMESTAMP_END_JULIAN   (109203528) /* == date2j(294277, 1, 1) */

Definition at line 253 of file timestamp.h.

◆ TIMESTAMP_INFINITY

#define TIMESTAMP_INFINITY   PG_INT64_MAX

Definition at line 151 of file timestamp.h.

◆ TIMESTAMP_IS_NOBEGIN

#define TIMESTAMP_IS_NOBEGIN (   j)    ((j) == DT_NOBEGIN)

Definition at line 162 of file timestamp.h.

◆ TIMESTAMP_IS_NOEND

#define TIMESTAMP_IS_NOEND (   j)    ((j) == DT_NOEND)

Definition at line 167 of file timestamp.h.

◆ TIMESTAMP_MINUS_INFINITY

#define TIMESTAMP_MINUS_INFINITY   PG_INT64_MIN

Definition at line 150 of file timestamp.h.

◆ TIMESTAMP_NOBEGIN

#define TIMESTAMP_NOBEGIN (   j)     do {(j) = DT_NOBEGIN;} while (0)

Definition at line 159 of file timestamp.h.

160 {(j) = DT_NOBEGIN;} while (0)
DT_NOBEGIN
#define DT_NOBEGIN
Definition timestamp.h:156
j
int j
Definition isn.c:78

◆ TIMESTAMP_NOEND

#define TIMESTAMP_NOEND (   j)     do {(j) = DT_NOEND;} while (0)

Definition at line 164 of file timestamp.h.

165 {(j) = DT_NOEND;} while (0)
DT_NOEND
#define DT_NOEND
Definition timestamp.h:157

◆ TIMESTAMP_NOT_FINITE

#define TIMESTAMP_NOT_FINITE (   j)    (TIMESTAMP_IS_NOBEGIN(j) || TIMESTAMP_IS_NOEND(j))

Definition at line 169 of file timestamp.h.

◆ TS_PREC_INV

#define TS_PREC_INV   1000000.0

Definition at line 99 of file timestamp.h.

◆ TSROUND

#define TSROUND (   j)    (rint(((double) (j)) * TS_PREC_INV) / TS_PREC_INV)

Definition at line 100 of file timestamp.h.

◆ TZDISP_LIMIT

#define TZDISP_LIMIT   ((MAX_TZDISP_HOUR + 1) * SECS_PER_HOUR)

Definition at line 144 of file timestamp.h.

◆ UNIX_EPOCH_JDATE

#define UNIX_EPOCH_JDATE   2440588 /* == date2j(1970, 1, 1) */

Definition at line 234 of file timestamp.h.

◆ USECS_PER_DAY

#define USECS_PER_DAY   INT64CONST(86400000000)

Definition at line 131 of file timestamp.h.

◆ USECS_PER_HOUR

#define USECS_PER_HOUR   INT64CONST(3600000000)

Definition at line 132 of file timestamp.h.

◆ USECS_PER_MINUTE

#define USECS_PER_MINUTE   INT64CONST(60000000)

Definition at line 133 of file timestamp.h.

◆ USECS_PER_SEC

#define USECS_PER_SEC   INT64CONST(1000000)

Definition at line 134 of file timestamp.h.

Typedef Documentation

◆ fsec_t

typedef int32 fsec_t

Definition at line 41 of file timestamp.h.

◆ TimeOffset

typedef int64 TimeOffset

Definition at line 40 of file timestamp.h.

◆ Timestamp

typedef int64 Timestamp

Definition at line 38 of file timestamp.h.

◆ TimestampTz

typedef int64 TimestampTz

Definition at line 39 of file timestamp.h.