PostgreSQL Source Code: src/include/utils/timestamp.h Source File (original) (raw)
1
2
3
4
5
6
7
8
9
10
11
12
13#ifndef TIMESTAMP_H
14#define TIMESTAMP_H
15
19
20
21
22
23
24
25
26
29{
31}
32
35{
37}
38
41{
43}
44
45static inline Datum
47{
49}
50
51static inline Datum
53{
55}
56
57static inline Datum
59{
61}
62
63#define PG_GETARG_TIMESTAMP(n) DatumGetTimestamp(PG_GETARG_DATUM(n))
64#define PG_GETARG_TIMESTAMPTZ(n) DatumGetTimestampTz(PG_GETARG_DATUM(n))
65#define PG_GETARG_INTERVAL_P(n) DatumGetIntervalP(PG_GETARG_DATUM(n))
66
67#define PG_RETURN_TIMESTAMP(x) return TimestampGetDatum(x)
68#define PG_RETURN_TIMESTAMPTZ(x) return TimestampTzGetDatum(x)
69#define PG_RETURN_INTERVAL_P(x) return IntervalPGetDatum(x)
70
71
72#define TIMESTAMP_MASK(b) (1 << (b))
73#define INTERVAL_MASK(b) (1 << (b))
74
75
76#define INTERVAL_FULL_RANGE (0x7FFF)
77#define INTERVAL_RANGE_MASK (0x7FFF)
78#define INTERVAL_FULL_PRECISION (0xFFFF)
79#define INTERVAL_PRECISION_MASK (0xFFFF)
80#define INTERVAL_TYPMOD(p,r) ((((r) & INTERVAL_RANGE_MASK) << 16) | ((p) & INTERVAL_PRECISION_MASK))
81#define INTERVAL_PRECISION(t) ((t) & INTERVAL_PRECISION_MASK)
82#define INTERVAL_RANGE(t) (((t) >> 16) & INTERVAL_RANGE_MASK)
83
84
85#define TimestampTzPlusMilliseconds(tz,ms) ((tz) + ((ms) * (int64) 1000))
86#define TimestampTzPlusSeconds(tz,s) ((tz) + ((s) * (int64) 1000000))
87
88
92{
94 return 0;
96}
97
98
100
101
103
104
105
106
108
113 long *secs, int *microsecs);
118 int msec);
121 int threshold_sec);
122
125
127
130 fsec_t *fsec, const char **tzn, pg_tz *attimezone);
132
136
139
141
142
143#define timestamptz_cmp_internal(dt1,dt2) timestamp_cmp_internal(dt1, dt2)
144
146 int *overflow);
149
150extern int isoweek2j(int year, int week);
151extern void isoweek2date(int woy, int *year, int *mon, int *mday);
152extern void isoweekdate2date(int isoweek, int wday, int *year, int *mon, int *mday);
153extern int date2isoweek(int year, int mon, int mday);
154extern int date2isoyear(int year, int mon, int mday);
156
158
159#endif
Datum Int64GetDatum(int64 X)
static int64 DatumGetInt64(Datum X)
static Datum PointerGetDatum(const void *X)
static Pointer DatumGetPointer(Datum X)
void dt2time(Timestamp jd, int *hour, int *min, int *sec, fsec_t *fsec)
int timestamp_cmp_internal(Timestamp dt1, Timestamp dt2)
long TimestampDifferenceMilliseconds(TimestampTz start_time, TimestampTz stop_time)
void isoweek2date(int woy, int *year, int *mon, int *mday)
void GetEpochTime(struct pg_tm *tm)
int itmin2interval(struct pg_itm_in *itm_in, Interval *span)
int isoweek2j(int year, int week)
TimestampTz time_t_to_timestamptz(pg_time_t tm)
static Datum TimestampTzGetDatum(TimestampTz X)
int date2isoweek(int year, int mon, int mday)
Timestamp SetEpochTimestamp(void)
static Datum TimestampGetDatum(Timestamp X)
static Datum IntervalPGetDatum(const Interval *X)
TimestampTz timestamp2timestamptz_opt_overflow(Timestamp timestamp, int *overflow)
int date2isoyearday(int year, int mon, int mday)
int tm2timestamp(struct pg_tm *tm, fsec_t fsec, int *tzp, Timestamp *result)
void TimestampDifference(TimestampTz start_time, TimestampTz stop_time, long *secs, int *microsecs)
bool TimestampDifferenceExceedsSeconds(TimestampTz start_time, TimestampTz stop_time, int threshold_sec)
bool TimestampTimestampTzRequiresRewrite(void)
void isoweekdate2date(int isoweek, int wday, int *year, int *mon, int *mday)
int32 timestamp_cmp_timestamptz_internal(Timestamp timestampVal, TimestampTz dt2)
bool TimestampDifferenceExceeds(TimestampTz start_time, TimestampTz stop_time, int msec)
PGDLLIMPORT TimestampTz PgReloadTime
PGDLLIMPORT TimestampTz PgStartTime
int timestamp2tm(Timestamp dt, int *tzp, struct pg_tm *tm, fsec_t *fsec, const char **tzn, pg_tz *attimezone)
int32 anytimestamp_typmod_check(bool istz, int32 typmod)
TimestampTz GetCurrentTimestamp(void)
const char * timestamptz_to_str(TimestampTz t)
static Interval * DatumGetIntervalP(Datum X)
Timestamp GetSQLLocalTimestamp(int32 typmod)
void interval2itm(Interval span, struct pg_itm *itm)
static uint64 TimestampDifferenceMicroseconds(TimestampTz start_time, TimestampTz stop_time)
static Timestamp DatumGetTimestamp(Datum X)
int itm2interval(struct pg_itm *itm, Interval *span)
pg_time_t timestamptz_to_time_t(TimestampTz t)
static TimestampTz DatumGetTimestampTz(Datum X)
int date2isoyear(int year, int mon, int mday)
TimestampTz GetSQLCurrentTimestamp(int32 typmod)