#include <math.h>
#include "fmgr.h"
#include "pgtime.h"
#include "datatype/timestamp.h"

Include dependency graph for date.h:

This graph shows which files directly or indirectly include this file:

Data Structures
struct	TimeTzADT

Macros
#define	DATEVAL_NOBEGIN ((DateADT) PG_INT32_MIN)

#define	DATEVAL_NOEND ((DateADT) PG_INT32_MAX)

#define	DATE_NOBEGIN(j) ((j) = DATEVAL_NOBEGIN)

#define	DATE_IS_NOBEGIN(j) ((j) == DATEVAL_NOBEGIN)

#define	DATE_NOEND(j) ((j) = DATEVAL_NOEND)

#define	DATE_IS_NOEND(j) ((j) == DATEVAL_NOEND)

#define	DATE_NOT_FINITE(j) (DATE_IS_NOBEGIN(j) \|\| DATE_IS_NOEND(j))

#define	MAX_TIME_PRECISION 6

#define	DatumGetDateADT(X) ((DateADT) DatumGetInt32(X))

#define	DatumGetTimeADT(X) ((TimeADT) DatumGetInt64(X))

#define	DatumGetTimeTzADTP(X) ((TimeTzADT *) DatumGetPointer(X))

#define	DateADTGetDatum(X) Int32GetDatum(X)

#define	TimeADTGetDatum(X) Int64GetDatum(X)

#define	TimeTzADTPGetDatum(X) PointerGetDatum(X)

#define	PG_GETARG_DATEADT(n) DatumGetDateADT(PG_GETARG_DATUM(n))

#define	PG_GETARG_TIMEADT(n) DatumGetTimeADT(PG_GETARG_DATUM(n))

#define	PG_GETARG_TIMETZADT_P(n) DatumGetTimeTzADTP(PG_GETARG_DATUM(n))

#define	PG_RETURN_DATEADT(x) return DateADTGetDatum(x)

#define	PG_RETURN_TIMEADT(x) return TimeADTGetDatum(x)

#define	PG_RETURN_TIMETZADT_P(x) return TimeTzADTPGetDatum(x)

Typedefs
typedef int32	DateADT

typedef int64	TimeADT

Functions
int32	anytime_typmod_check (bool istz, int32 typmod)

double	date2timestamp_no_overflow (DateADT dateVal)

void	EncodeSpecialDate (DateADT dt, char *str)

DateADT	GetSQLCurrentDate (void)

TimeTzADT *	GetSQLCurrentTime (int32 typmod)

TimeADT	GetSQLLocalTime (int32 typmod)

int	time2tm (TimeADT time, struct pg_tm tm, fsec_t fsec)

int	timetz2tm (TimeTzADT time, struct pg_tm tm, fsec_t fsec, int tzp)

Macro Definition Documentation

◆ DATE_IS_NOBEGIN

#define DATE_IS_NOBEGIN ( j ) ((j) == DATEVAL_NOBEGIN)

Definition at line 40 of file date.h.

Referenced by date2timestamp(), date2timestamp_no_overflow(), date2timestamptz(), datetimetz_timestamptz(), and EncodeSpecialDate().

◆ DATE_IS_NOEND

#define DATE_IS_NOEND ( j ) ((j) == DATEVAL_NOEND)

Definition at line 42 of file date.h.

Referenced by date2timestamp(), date2timestamp_no_overflow(), date2timestamptz(), datetimetz_timestamptz(), and EncodeSpecialDate().

◆ DATE_NOBEGIN

#define DATE_NOBEGIN ( j ) ((j) = DATEVAL_NOBEGIN)

Definition at line 39 of file date.h.

Referenced by date_in(), timestamp_date(), and timestamptz_date().

◆ DATE_NOEND

#define DATE_NOEND ( j ) ((j) = DATEVAL_NOEND)

Definition at line 41 of file date.h.

Referenced by date_in(), timestamp_date(), and timestamptz_date().

◆ DATE_NOT_FINITE

#define DATE_NOT_FINITE ( j ) (DATE_IS_NOBEGIN(j) || DATE_IS_NOEND(j))

Definition at line 43 of file date.h.

Referenced by date_finite(), date_mi(), date_mii(), date_out(), date_pli(), date_recv(), daterange_canonical(), JsonEncodeDateTime(), and map_sql_value_to_xml_value().

◆ DateADTGetDatum

#define DateADTGetDatum ( X ) Int32GetDatum(X)

Definition at line 57 of file date.h.

Referenced by ExecEvalSQLValueFunction(), gbt_date_penalty(), gbt_dateeq(), gbt_datege(), gbt_dategt(), gbt_datekey_cmp(), gbt_datele(), gbt_datelt(), gbt_num_fetch(), gdb_date_dist(), and leftmostvalue_date().

◆ DATEVAL_NOBEGIN

#define DATEVAL_NOBEGIN ((DateADT) PG_INT32_MIN)

Definition at line 36 of file date.h.

Referenced by leftmostvalue_date().

◆ DATEVAL_NOEND

#define DATEVAL_NOEND ((DateADT) PG_INT32_MAX)

Definition at line 37 of file date.h.

◆ DatumGetDateADT

#define DatumGetDateADT ( X ) ((DateADT) DatumGetInt32(X))

Definition at line 53 of file date.h.

Referenced by convert_timevalue_to_scalar(), date_fastcmp(), daterange_canonical(), gbt_num_compress(), JsonEncodeDateTime(), and map_sql_value_to_xml_value().

◆ DatumGetTimeADT

#define DatumGetTimeADT ( X ) ((TimeADT) DatumGetInt64(X))

Definition at line 54 of file date.h.

Referenced by convert_timevalue_to_scalar(), gbt_num_compress(), and JsonEncodeDateTime().

◆ DatumGetTimeTzADTP

#define DatumGetTimeTzADTP ( X ) ((TimeTzADT *) DatumGetPointer(X))

Definition at line 55 of file date.h.

Referenced by convert_timevalue_to_scalar(), gbt_timetz_compress(), and JsonEncodeDateTime().

◆ MAX_TIME_PRECISION

#define MAX_TIME_PRECISION 6

Definition at line 51 of file date.h.

Referenced by AdjustTimeForTypmod(), anytime_typmod_check(), EncodeTimeOnly(), and time_support().

◆ PG_GETARG_DATEADT

#define PG_GETARG_DATEADT ( n ) DatumGetDateADT(PG_GETARG_DATUM(n))

Definition at line 61 of file date.h.

Referenced by date_cmp(), date_cmp_timestamp(), date_cmp_timestamptz(), date_eq(), date_eq_timestamp(), date_eq_timestamptz(), date_finite(), date_ge(), date_ge_timestamp(), date_ge_timestamptz(), date_gt(), date_gt_timestamp(), date_gt_timestamptz(), date_larger(), date_le(), date_le_timestamp(), date_le_timestamptz(), date_lt(), date_lt_timestamp(), date_lt_timestamptz(), date_mi(), date_mi_interval(), date_mii(), date_ne(), date_ne_timestamp(), date_ne_timestamptz(), date_out(), date_pl_interval(), date_pli(), date_send(), date_smaller(), date_timestamp(), date_timestamptz(), datetime_timestamp(), datetimetz_timestamptz(), gbt_date_consistent(), gbt_date_distance(), in_range_date_interval(), timestamp_cmp_date(), timestamp_eq_date(), timestamp_ge_date(), timestamp_gt_date(), timestamp_le_date(), timestamp_lt_date(), timestamp_ne_date(), timestamptz_cmp_date(), timestamptz_eq_date(), timestamptz_ge_date(), timestamptz_gt_date(), timestamptz_le_date(), timestamptz_lt_date(), and timestamptz_ne_date().

◆ PG_GETARG_TIMEADT

#define PG_GETARG_TIMEADT ( n ) DatumGetTimeADT(PG_GETARG_DATUM(n))

Definition at line 62 of file date.h.

Referenced by datetime_timestamp(), gbt_time_consistent(), gbt_time_distance(), in_range_time_interval(), time_cmp(), time_eq(), time_ge(), time_gt(), time_interval(), time_larger(), time_le(), time_lt(), time_mi_interval(), time_mi_time(), time_ne(), time_out(), time_part(), time_pl_interval(), time_scale(), time_send(), time_smaller(), and time_timetz().

◆ PG_GETARG_TIMETZADT_P

#define PG_GETARG_TIMETZADT_P ( n ) DatumGetTimeTzADTP(PG_GETARG_DATUM(n))

Definition at line 63 of file date.h.

Referenced by datetimetz_timestamptz(), gbt_timetz_consistent(), in_range_timetz_interval(), timetz_cmp(), timetz_eq(), timetz_ge(), timetz_gt(), timetz_hash(), timetz_hash_extended(), timetz_izone(), timetz_larger(), timetz_le(), timetz_lt(), timetz_mi_interval(), timetz_ne(), timetz_out(), timetz_part(), timetz_pl_interval(), timetz_scale(), timetz_send(), timetz_smaller(), timetz_time(), and timetz_zone().

◆ PG_RETURN_DATEADT

#define PG_RETURN_DATEADT ( x ) return DateADTGetDatum(x)

Definition at line 65 of file date.h.

Referenced by date_in(), date_larger(), date_mii(), date_pli(), date_recv(), date_smaller(), make_date(), timestamp_date(), timestamptz_date(), and to_date().

◆ PG_RETURN_TIMEADT

#define PG_RETURN_TIMEADT ( x ) return TimeADTGetDatum(x)

Definition at line 66 of file date.h.

Referenced by interval_time(), make_time(), time_in(), time_larger(), time_mi_interval(), time_pl_interval(), time_recv(), time_scale(), time_smaller(), timestamp_time(), timestamptz_time(), and timetz_time().

◆ PG_RETURN_TIMETZADT_P

#define PG_RETURN_TIMETZADT_P ( x ) return TimeTzADTPGetDatum(x)

Definition at line 67 of file date.h.

Referenced by time_timetz(), timestamptz_timetz(), timetz_in(), timetz_izone(), timetz_larger(), timetz_mi_interval(), timetz_pl_interval(), timetz_recv(), timetz_scale(), timetz_smaller(), and timetz_zone().

◆ TimeADTGetDatum

#define TimeADTGetDatum ( X ) Int64GetDatum(X)

Definition at line 58 of file date.h.

Referenced by ExecEvalSQLValueFunction(), gbt_num_fetch(), and leftmostvalue_time().

◆ TimeTzADTPGetDatum

#define TimeTzADTPGetDatum ( X ) PointerGetDatum(X)

Definition at line 59 of file date.h.

Referenced by ExecEvalSQLValueFunction(), and leftmostvalue_timetz().

Typedef Documentation

◆ DateADT

typedef int32 DateADT

Definition at line 23 of file date.h.

◆ TimeADT

typedef int64 TimeADT

Definition at line 25 of file date.h.

Function Documentation

◆ anytime_typmod_check()

int32 anytime_typmod_check	(	bool	istz,
		int32	typmod
	)

Definition at line 72 of file date.c.

References ereport, errcode(), errmsg(), ERROR, MAX_TIME_PRECISION, and WARNING.

Referenced by anytime_typmodin(), and transformSQLValueFunction().

 {
     if (typmod < 0)
         ereport(ERROR,
                 (errcode(ERRCODE_INVALID_PARAMETER_VALUE),
                  errmsg("TIME(%d)%s precision must not be negative",
                         typmod, (istz ? " WITH TIME ZONE" : ""))));
     if (typmod > MAX_TIME_PRECISION)
     {
         ereport(WARNING,
                 (errcode(ERRCODE_INVALID_PARAMETER_VALUE),
                  errmsg("TIME(%d)%s precision reduced to maximum allowed, %d",
                         typmod, (istz ? " WITH TIME ZONE" : ""),
                         MAX_TIME_PRECISION)));
         typmod = MAX_TIME_PRECISION;
     }
 
     return typmod;
 }

◆ date2timestamp_no_overflow()

double date2timestamp_no_overflow ( DateADT dateVal )

Definition at line 648 of file date.c.

References DATE_IS_NOBEGIN, DATE_IS_NOEND, and USECS_PER_DAY.

Referenced by convert_timevalue_to_scalar().

 {
     double      result;
 
     if (DATE_IS_NOBEGIN(dateVal))
         result = -DBL_MAX;
     else if (DATE_IS_NOEND(dateVal))
         result = DBL_MAX;
     else
     {
         /* date is days since 2000, timestamp is microseconds since same... */
         result = dateVal * (double) USECS_PER_DAY;
     }
 
     return result;
 }

◆ EncodeSpecialDate()

void EncodeSpecialDate	(	DateADT	dt,
		char *	str
	)

Definition at line 289 of file date.c.

References DATE_IS_NOBEGIN, DATE_IS_NOEND, EARLY, elog, ERROR, and LATE.

Referenced by date_out(), and JsonEncodeDateTime().

 {
     if (DATE_IS_NOBEGIN(dt))
         strcpy(str, EARLY);
     else if (DATE_IS_NOEND(dt))
         strcpy(str, LATE);
     else                        /* shouldn't happen */
         elog(ERROR, "invalid argument for EncodeSpecialDate");
 }

◆ GetSQLCurrentDate()

DateADT GetSQLCurrentDate ( void )

Definition at line 304 of file date.c.

References date2j(), ereport, errcode(), errmsg(), ERROR, GetCurrentTransactionStartTimestamp(), POSTGRES_EPOCH_JDATE, timestamp2tm(), tm, pg_tm::tm_mday, pg_tm::tm_mon, and pg_tm::tm_year.

Referenced by ExecEvalSQLValueFunction().

 {
     TimestampTz ts;
     struct pg_tm tt,
                *tm = &tt;
     fsec_t      fsec;
     int         tz;
 
     ts = GetCurrentTransactionStartTimestamp();
 
     if (timestamp2tm(ts, &tz, tm, &fsec, NULL, NULL) != 0)
         ereport(ERROR,
                 (errcode(ERRCODE_DATETIME_VALUE_OUT_OF_RANGE),
                  errmsg("timestamp out of range")));
 
     return date2j(tm->tm_year, tm->tm_mon, tm->tm_mday) - POSTGRES_EPOCH_JDATE;
 }

◆ GetSQLCurrentTime()

TimeTzADT* GetSQLCurrentTime ( int32 typmod )

Definition at line 326 of file date.c.

References AdjustTimeForTypmod(), ereport, errcode(), errmsg(), ERROR, GetCurrentTransactionStartTimestamp(), palloc(), TimeTzADT::time, timestamp2tm(), tm, and tm2timetz().

Referenced by ExecEvalSQLValueFunction().

 {
     TimeTzADT  *result;
     TimestampTz ts;
     struct pg_tm tt,
                *tm = &tt;
     fsec_t      fsec;
     int         tz;
 
     ts = GetCurrentTransactionStartTimestamp();
 
     if (timestamp2tm(ts, &tz, tm, &fsec, NULL, NULL) != 0)
         ereport(ERROR,
                 (errcode(ERRCODE_DATETIME_VALUE_OUT_OF_RANGE),
                  errmsg("timestamp out of range")));
 
     result = (TimeTzADT *) palloc(sizeof(TimeTzADT));
     tm2timetz(tm, fsec, tz, result);
     AdjustTimeForTypmod(&(result->time), typmod);
     return result;
 }

◆ GetSQLLocalTime()

TimeADT GetSQLLocalTime ( int32 typmod )

Definition at line 352 of file date.c.

References AdjustTimeForTypmod(), ereport, errcode(), errmsg(), ERROR, GetCurrentTransactionStartTimestamp(), timestamp2tm(), tm, and tm2time().

Referenced by ExecEvalSQLValueFunction().

 {
     TimeADT     result;
     TimestampTz ts;
     struct pg_tm tt,
                *tm = &tt;
     fsec_t      fsec;
     int         tz;
 
     ts = GetCurrentTransactionStartTimestamp();
 
     if (timestamp2tm(ts, &tz, tm, &fsec, NULL, NULL) != 0)
         ereport(ERROR,
                 (errcode(ERRCODE_DATETIME_VALUE_OUT_OF_RANGE),
                  errmsg("timestamp out of range")));
 
     tm2time(tm, fsec, &result);
     AdjustTimeForTypmod(&result, typmod);
     return result;
 }

◆ time2tm()

int time2tm	(	TimeADT	time,
		struct pg_tm *	tm,
		fsec_t *	fsec
	)

Definition at line 1222 of file date.c.

References pg_tm::tm_hour, pg_tm::tm_min, pg_tm::tm_sec, USECS_PER_HOUR, USECS_PER_MINUTE, and USECS_PER_SEC.

Referenced by JsonEncodeDateTime(), time_out(), time_part(), and time_timetz().

 {
     tm->tm_hour = time / USECS_PER_HOUR;
     time -= tm->tm_hour * USECS_PER_HOUR;
     tm->tm_min = time / USECS_PER_MINUTE;
     time -= tm->tm_min * USECS_PER_MINUTE;
     tm->tm_sec = time / USECS_PER_SEC;
     time -= tm->tm_sec * USECS_PER_SEC;
     *fsec = time;
     return 0;
 }

◆ timetz2tm()

int timetz2tm	(	TimeTzADT *	time,
		struct pg_tm *	tm,
		fsec_t *	fsec,
		int *	tzp
	)

Definition at line 2095 of file date.c.

References TimeTzADT::time, pg_tm::tm_hour, pg_tm::tm_min, pg_tm::tm_sec, USECS_PER_HOUR, USECS_PER_MINUTE, USECS_PER_SEC, and TimeTzADT::zone.

Referenced by JsonEncodeDateTime(), timetz_out(), and timetz_part().

 {
     TimeOffset  trem = time->time;
 
     tm->tm_hour = trem / USECS_PER_HOUR;
     trem -= tm->tm_hour * USECS_PER_HOUR;
     tm->tm_min = trem / USECS_PER_MINUTE;
     trem -= tm->tm_min * USECS_PER_MINUTE;
     tm->tm_sec = trem / USECS_PER_SEC;
     *fsec = trem - tm->tm_sec * USECS_PER_SEC;
 
     if (tzp != NULL)
         *tzp = time->zone;
 
     return 0;
 }

Data Structures

Macros

Typedefs

Functions

Macro Definition Documentation

◆ DATE_IS_NOBEGIN

◆ DATE_IS_NOEND

◆ DATE_NOBEGIN

◆ DATE_NOEND

◆ DATE_NOT_FINITE

◆ DateADTGetDatum

◆ DATEVAL_NOBEGIN

◆ DATEVAL_NOEND

◆ DatumGetDateADT

◆ DatumGetTimeADT

◆ DatumGetTimeTzADTP

◆ MAX_TIME_PRECISION

◆ PG_GETARG_DATEADT

◆ PG_GETARG_TIMEADT

◆ PG_GETARG_TIMETZADT_P

◆ PG_RETURN_DATEADT

◆ PG_RETURN_TIMEADT

◆ PG_RETURN_TIMETZADT_P

◆ TimeADTGetDatum

◆ TimeTzADTPGetDatum

Typedef Documentation

◆ DateADT

◆ TimeADT

Function Documentation

◆ anytime_typmod_check()

◆ date2timestamp_no_overflow()

◆ EncodeSpecialDate()

◆ GetSQLCurrentDate()

◆ GetSQLCurrentTime()

◆ GetSQLLocalTime()

◆ time2tm()

◆ timetz2tm()