date.h File Reference

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

Include dependency graph for date.h:

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

Go to the source code of 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)
Timestamp	date2timestamp_opt_overflow (DateADT dateVal, int *overflow)
TimestampTz	date2timestamptz_opt_overflow (DateADT dateVal, int *overflow)
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)
int	tm2time (struct pg_tm *tm, fsec_t fsec, TimeADT *result)
int	tm2timetz (struct pg_tm *tm, fsec_t fsec, int tz, TimeTzADT *result)
bool	time_overflows (int hour, int min, int sec, fsec_t fsec)
bool	float_time_overflows (int hour, int min, double sec)
void	AdjustTimeForTypmod (TimeADT *time, int32 typmod)

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_no_overflow(), date2timestamp_opt_overflow(), date2timestamptz_opt_overflow(), 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_no_overflow(), date2timestamp_opt_overflow(), date2timestamptz_opt_overflow(), 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(), leftmostvalue_date(), and parse_datetime().

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 compareDatetime(), 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(), leftmostvalue_time(), and parse_datetime().

TimeTzADTPGetDatum

#define TimeTzADTPGetDatum

(

X

)

PointerGetDatum(X)

Definition at line 59 of file date.h.

Referenced by ExecEvalSQLValueFunction(), leftmostvalue_timetz(), and parse_datetime().

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

AdjustTimeForTypmod()

void AdjustTimeForTypmod	(	TimeADT *	time,
		int32	typmod
	)

Definition at line 1498 of file date.c.

References MAX_TIME_PRECISION.

Referenced by GetSQLCurrentTime(), GetSQLLocalTime(), parse_datetime(), time_in(), time_recv(), time_scale(), timetz_in(), timetz_recv(), and timetz_scale().

{
    static const int64 TimeScales[MAX_TIME_PRECISION + 1] = {
        INT64CONST(1000000),
        INT64CONST(100000),
        INT64CONST(10000),
        INT64CONST(1000),
        INT64CONST(100),
        INT64CONST(10),
        INT64CONST(1)
    };

    static const int64 TimeOffsets[MAX_TIME_PRECISION + 1] = {
        INT64CONST(500000),
        INT64CONST(50000),
        INT64CONST(5000),
        INT64CONST(500),
        INT64CONST(50),
        INT64CONST(5),
        INT64CONST(0)
    };

    if (typmod >= 0 && typmod <= MAX_TIME_PRECISION)
    {
        if (*time >= INT64CONST(0))
            *time = ((*time + TimeOffsets[typmod]) / TimeScales[typmod]) *
                TimeScales[typmod];
        else
            *time = -((((-*time) + TimeOffsets[typmod]) / TimeScales[typmod]) *
                      TimeScales[typmod]);
    }
}

anytime_typmod_check()

int32 anytime_typmod_check	(	bool	istz,
		int32	typmod
	)

Definition at line 68 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 708 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;
}

date2timestamp_opt_overflow()

Timestamp date2timestamp_opt_overflow	(	DateADT	dateVal,
		int *	overflow
	)

Definition at line 563 of file date.c.

References DATE_IS_NOBEGIN, DATE_IS_NOEND, ereport, errcode(), errmsg(), ERROR, POSTGRES_EPOCH_JDATE, TIMESTAMP_END_JULIAN, TIMESTAMP_NOBEGIN, TIMESTAMP_NOEND, and USECS_PER_DAY.

Referenced by cmpDateToTimestamp(), and date2timestamp().

{
    Timestamp   result;

    if (DATE_IS_NOBEGIN(dateVal))
        TIMESTAMP_NOBEGIN(result);
    else if (DATE_IS_NOEND(dateVal))
        TIMESTAMP_NOEND(result);
    else
    {
        /*
         * Date's range is wider than timestamp's, so check for boundaries.
         * Since dates have the same minimum values as timestamps, only upper
         * boundary need be checked for overflow.
         */
        if (dateVal >= (TIMESTAMP_END_JULIAN - POSTGRES_EPOCH_JDATE))
        {
            if (overflow)
            {
                *overflow = 1;
                return (Timestamp) 0;
            }
            else
            {
                ereport(ERROR,
                        (errcode(ERRCODE_DATETIME_VALUE_OUT_OF_RANGE),
                         errmsg("date out of range for timestamp")));
            }
        }

        /* date is days since 2000, timestamp is microseconds since same... */
        result = dateVal * USECS_PER_DAY;
    }

    return result;
}

date2timestamptz_opt_overflow()

TimestampTz date2timestamptz_opt_overflow	(	DateADT	dateVal,
		int *	overflow
	)

Definition at line 617 of file date.c.

References Assert, DATE_IS_NOBEGIN, DATE_IS_NOEND, DetermineTimeZoneOffset(), END_TIMESTAMP, ereport, errcode(), errmsg(), ERROR, IS_VALID_TIMESTAMP, j2date(), MIN_TIMESTAMP, POSTGRES_EPOCH_JDATE, session_timezone, TIMESTAMP_END_JULIAN, TIMESTAMP_NOBEGIN, TIMESTAMP_NOEND, tm, pg_tm::tm_hour, pg_tm::tm_mday, pg_tm::tm_min, pg_tm::tm_mon, pg_tm::tm_sec, pg_tm::tm_year, USECS_PER_DAY, and USECS_PER_SEC.

Referenced by cmpDateToTimestampTz(), and date2timestamptz().

{
    TimestampTz result;
    struct pg_tm tt,
               *tm = &tt;
    int         tz;

    if (DATE_IS_NOBEGIN(dateVal))
        TIMESTAMP_NOBEGIN(result);
    else if (DATE_IS_NOEND(dateVal))
        TIMESTAMP_NOEND(result);
    else
    {
        /*
         * Date's range is wider than timestamp's, so check for boundaries.
         * Since dates have the same minimum values as timestamps, only upper
         * boundary need be checked for overflow.
         */
        if (dateVal >= (TIMESTAMP_END_JULIAN - POSTGRES_EPOCH_JDATE))
        {
            if (overflow)
            {
                *overflow = 1;
                return (TimestampTz) 0;
            }
            else
            {
                ereport(ERROR,
                        (errcode(ERRCODE_DATETIME_VALUE_OUT_OF_RANGE),
                         errmsg("date out of range for timestamp")));
            }
        }

        j2date(dateVal + POSTGRES_EPOCH_JDATE,
               &(tm->tm_year), &(tm->tm_mon), &(tm->tm_mday));
        tm->tm_hour = 0;
        tm->tm_min = 0;
        tm->tm_sec = 0;
        tz = DetermineTimeZoneOffset(tm, session_timezone);

        result = dateVal * USECS_PER_DAY + tz * USECS_PER_SEC;

        /*
         * Since it is possible to go beyond allowed timestamptz range because
         * of time zone, check for allowed timestamp range after adding tz.
         */
        if (!IS_VALID_TIMESTAMP(result))
        {
            if (overflow)
            {
                if (result < MIN_TIMESTAMP)
                    *overflow = -1;
                else
                {
                    Assert(result >= END_TIMESTAMP);
                    *overflow = 1;
                }
                return (TimestampTz) 0;
            }
            else
            {
                ereport(ERROR,
                        (errcode(ERRCODE_DATETIME_VALUE_OUT_OF_RANGE),
                         errmsg("date out of range for timestamp")));
            }
        }
    }

    return result;
}

EncodeSpecialDate()

void EncodeSpecialDate	(	DateADT	dt,
		char *	str
	)

Definition at line 285 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");
}

float_time_overflows()

bool float_time_overflows	(	int	hour,
		int	min,
		double	sec
	)

Definition at line 1302 of file date.c.

References HOURS_PER_DAY, MINS_PER_HOUR, SECS_PER_MINUTE, USECS_PER_DAY, and USECS_PER_SEC.

Referenced by make_time(), and make_timestamp_internal().

{
    /* Range-check the fields individually. */
    if (hour < 0 || hour > HOURS_PER_DAY ||
        min < 0 || min >= MINS_PER_HOUR)
        return true;

    /*
     * "sec", being double, requires extra care.  Cope with NaN, and round off
     * before applying the range check to avoid unexpected errors due to
     * imprecise input.  (We assume rint() behaves sanely with infinities.)
     */
    if (isnan(sec))
        return true;
    sec = rint(sec * USECS_PER_SEC);
    if (sec < 0 || sec > SECS_PER_MINUTE * USECS_PER_SEC)
        return true;

    /*
     * Because we allow, eg, hour = 24 or sec = 60, we must check separately
     * that the total time value doesn't exceed 24:00:00.  This must match the
     * way that callers will convert the fields to a time.
     */
    if (((((hour * MINS_PER_HOUR + min) * SECS_PER_MINUTE)
          * USECS_PER_SEC) + (int64) sec) > USECS_PER_DAY)
        return true;

    return false;
}

GetSQLCurrentDate()

DateADT GetSQLCurrentDate

(

void

)

Definition at line 300 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 322 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 348 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 1341 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;
}

time_overflows()

bool time_overflows	(	int	hour,
		int	min,
		int	sec,
		fsec_t	fsec
	)

Definition at line 1278 of file date.c.

References HOURS_PER_DAY, MINS_PER_HOUR, SECS_PER_MINUTE, USECS_PER_DAY, and USECS_PER_SEC.

Referenced by DecodeDateTime(), and DecodeTimeOnly().

{
    /* Range-check the fields individually. */
    if (hour < 0 || hour > HOURS_PER_DAY ||
        min < 0 || min >= MINS_PER_HOUR ||
        sec < 0 || sec > SECS_PER_MINUTE ||
        fsec < 0 || fsec > USECS_PER_SEC)
        return true;

    /*
     * Because we allow, eg, hour = 24 or sec = 60, we must check separately
     * that the total time value doesn't exceed 24:00:00.
     */
    if ((((((hour * MINS_PER_HOUR + min) * SECS_PER_MINUTE)
           + sec) * USECS_PER_SEC) + fsec) > USECS_PER_DAY)
        return true;

    return false;
}

timetz2tm()

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

Definition at line 2210 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;
}

tm2time()

int tm2time	(	struct pg_tm *	tm,
		fsec_t	fsec,
		TimeADT *	result
	)

Definition at line 1267 of file date.c.

References MINS_PER_HOUR, SECS_PER_MINUTE, pg_tm::tm_hour, pg_tm::tm_min, pg_tm::tm_sec, and USECS_PER_SEC.

Referenced by GetSQLLocalTime(), parse_datetime(), and time_in().

{
    *result = ((((tm->tm_hour * MINS_PER_HOUR + tm->tm_min) * SECS_PER_MINUTE) + tm->tm_sec)
               * USECS_PER_SEC) + fsec;
    return 0;
}

tm2timetz()

int tm2timetz	(	struct pg_tm *	tm,
		fsec_t	fsec,
		int	tz,
		TimeTzADT *	result
	)

Definition at line 2076 of file date.c.

References MINS_PER_HOUR, SECS_PER_MINUTE, TimeTzADT::time, pg_tm::tm_hour, pg_tm::tm_min, pg_tm::tm_sec, USECS_PER_SEC, and TimeTzADT::zone.

Referenced by GetSQLCurrentTime(), parse_datetime(), timestamptz_timetz(), and timetz_in().

{
    result->time = ((((tm->tm_hour * MINS_PER_HOUR + tm->tm_min) * SECS_PER_MINUTE) + tm->tm_sec) *
                    USECS_PER_SEC) + fsec;
    result->zone = tz;

    return 0;
}