date.h File Reference

#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	TIMETZ_TYPLEN   12
#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	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
static DateADT	DatumGetDateADT (Datum X)
static TimeADT	DatumGetTimeADT (Datum X)
static TimeTzADT *	DatumGetTimeTzADTP (Datum X)
static Datum	DateADTGetDatum (DateADT X)
static Datum	TimeADTGetDatum (TimeADT X)
static Datum	TimeTzADTPGetDatum (const TimeTzADT *X)
int32	anytime_typmod_check (bool istz, int32 typmod)
double	date2timestamp_no_overflow (DateADT dateVal)
Timestamp	date2timestamp_safe (DateADT dateVal, Node *escontext)
TimestampTz	date2timestamptz_safe (DateADT dateVal, Node *escontext)
DateADT	timestamp2date_safe (Timestamp timestamp, Node *escontext)
DateADT	timestamptz2date_safe (TimestampTz timestamp, Node *escontext)
int32	date_cmp_timestamp_internal (DateADT dateVal, Timestamp dt2)
int32	date_cmp_timestamptz_internal (DateADT dateVal, TimestampTz dt2)
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 46 of file date.h.

DATE_IS_NOEND

#define DATE_IS_NOEND

(

j

)

((j) == DATEVAL_NOEND)

Definition at line 48 of file date.h.

DATE_NOBEGIN

#define DATE_NOBEGIN

(

j

)

((j) = DATEVAL_NOBEGIN)

Definition at line 45 of file date.h.

DATE_NOEND

#define DATE_NOEND

(

j

)

((j) = DATEVAL_NOEND)

Definition at line 47 of file date.h.

DATE_NOT_FINITE

#define DATE_NOT_FINITE

(

j

)

(DATE_IS_NOBEGIN(j) || DATE_IS_NOEND(j))

Definition at line 49 of file date.h.

DATEVAL_NOBEGIN

#define DATEVAL_NOBEGIN   ((DateADT) PG_INT32_MIN)

Definition at line 42 of file date.h.

DATEVAL_NOEND

#define DATEVAL_NOEND   ((DateADT) PG_INT32_MAX)

Definition at line 43 of file date.h.

MAX_TIME_PRECISION

#define MAX_TIME_PRECISION   6

Definition at line 51 of file date.h.

PG_GETARG_DATEADT

#define PG_GETARG_DATEADT

(

n

)

DatumGetDateADT(PG_GETARG_DATUM(n))

Definition at line 95 of file date.h.

PG_GETARG_TIMEADT

#define PG_GETARG_TIMEADT

(

n

)

DatumGetTimeADT(PG_GETARG_DATUM(n))

Definition at line 96 of file date.h.

PG_GETARG_TIMETZADT_P

#define PG_GETARG_TIMETZADT_P

(

n

)

DatumGetTimeTzADTP(PG_GETARG_DATUM(n))

Definition at line 97 of file date.h.

PG_RETURN_DATEADT

#define PG_RETURN_DATEADT

(

x

)

return DateADTGetDatum(x)

Definition at line 99 of file date.h.

PG_RETURN_TIMEADT

#define PG_RETURN_TIMEADT

(

x

)

return TimeADTGetDatum(x)

Definition at line 100 of file date.h.

PG_RETURN_TIMETZADT_P

#define PG_RETURN_TIMETZADT_P

(

x

)

return TimeTzADTPGetDatum(x)

Definition at line 101 of file date.h.

TIMETZ_TYPLEN

#define TIMETZ_TYPLEN   12

Definition at line 37 of file date.h.

Typedef Documentation

DateADT

typedef int32 DateADT

Definition at line 21 of file date.h.

TimeADT

typedef int64 TimeADT

Definition at line 23 of file date.h.

Function Documentation

AdjustTimeForTypmod()

void AdjustTimeForTypmod ( TimeADT *  time, int32  typmod  )

extern

Definition at line 1753 of file date.c.

{
    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]);
    }
}

References fb(), INT64CONST, and MAX_TIME_PRECISION.

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

anytime_typmod_check()

int32 anytime_typmod_check ( bool  istz, int32  typmod  )

extern

Definition at line 65 of file date.c.

{
    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;
}

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

Referenced by anytime_typmodin(), executeDateTimeMethod(), and transformSQLValueFunction().

date2timestamp_no_overflow()

double date2timestamp_no_overflow ( DateADT  dateVal )

extern

Definition at line 741 of file date.c.

{
    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;
}

References DATE_IS_NOBEGIN, DATE_IS_NOEND, fb(), result, and USECS_PER_DAY.

Referenced by convert_timevalue_to_scalar().

date2timestamp_safe()

Timestamp date2timestamp_safe ( DateADT  dateVal, Node *  escontext  )

extern

Definition at line 627 of file date.c.

{
    Timestamp   result;
 
    if (DATE_IS_NOBEGIN(dateVal))
        TIMESTAMP_NOBEGIN(result);
    else if (DATE_IS_NOEND(dateVal))
        TIMESTAMP_NOEND(result);
    else
    {
        /*
         * 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))
        {
            TIMESTAMP_NOEND(result);
            ereturn(escontext, result,
                    (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;
}

References DATE_IS_NOBEGIN, DATE_IS_NOEND, ereturn, errcode(), errmsg, fb(), POSTGRES_EPOCH_JDATE, result, TIMESTAMP_END_JULIAN, TIMESTAMP_NOBEGIN, TIMESTAMP_NOEND, and USECS_PER_DAY.

Referenced by cvt_date_timestamp(), date2timestamp(), date_cmp_timestamp_internal(), and date_timestamp().

date2timestamptz_safe()

TimestampTz date2timestamptz_safe ( DateADT  dateVal, Node *  escontext  )

extern

Definition at line 676 of file date.c.

{
    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
    {
        /*
         * 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))
        {
            TIMESTAMP_NOEND(result);
            ereturn(escontext, result,
                    (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 (result < MIN_TIMESTAMP)
                TIMESTAMP_NOBEGIN(result);
            else
                TIMESTAMP_NOEND(result);
 
            ereturn(escontext, result,
                    (errcode(ERRCODE_DATETIME_VALUE_OUT_OF_RANGE),
                     errmsg("date out of range for timestamp")));
        }
    }
 
    return result;
}

References DATE_IS_NOBEGIN, DATE_IS_NOEND, DetermineTimeZoneOffset(), ereturn, errcode(), errmsg, fb(), IS_VALID_TIMESTAMP, j2date(), MIN_TIMESTAMP, POSTGRES_EPOCH_JDATE, result, 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 cvt_date_timestamptz(), date_cmp_timestamptz_internal(), and date_timestamptz().

date_cmp_timestamp_internal()

int32 date_cmp_timestamp_internal ( DateADT  dateVal, Timestamp  dt2  )

extern

Definition at line 764 of file date.c.

{
    Timestamp   dt1;
    ErrorSaveContext escontext = {T_ErrorSaveContext};
 
    dt1 = date2timestamp_safe(dateVal, (Node *) &escontext);
    if (escontext.error_occurred)
    {
        Assert(TIMESTAMP_IS_NOEND(dt1));    /* NOBEGIN case cannot occur */
 
        /* dt1 is larger than any finite timestamp, but less than infinity */
        return TIMESTAMP_IS_NOEND(dt2) ? -1 : +1;
    }
 
    return timestamp_cmp_internal(dt1, dt2);
}

References Assert, date2timestamp_safe(), ErrorSaveContext::error_occurred, fb(), timestamp_cmp_internal(), and TIMESTAMP_IS_NOEND.

Referenced by cmpDateToTimestamp(), date_cmp_timestamp(), date_eq_timestamp(), date_ge_timestamp(), date_gt_timestamp(), date_le_timestamp(), date_lt_timestamp(), date_ne_timestamp(), timestamp_cmp_date(), timestamp_eq_date(), timestamp_ge_date(), timestamp_gt_date(), timestamp_le_date(), timestamp_lt_date(), and timestamp_ne_date().

date_cmp_timestamptz_internal()

int32 date_cmp_timestamptz_internal ( DateADT  dateVal, TimestampTz  dt2  )

extern

Definition at line 845 of file date.c.

{
    TimestampTz dt1;
    ErrorSaveContext escontext = {T_ErrorSaveContext};
 
    dt1 = date2timestamptz_safe(dateVal, (Node *) &escontext);
 
    if (escontext.error_occurred)
    {
        if (TIMESTAMP_IS_NOEND(dt1))
        {
            /* dt1 is larger than any finite timestamp, but less than infinity */
            return TIMESTAMP_IS_NOEND(dt2) ? -1 : +1;
        }
        if (TIMESTAMP_IS_NOBEGIN(dt1))
        {
            /* dt1 is less than any finite timestamp, but more than -infinity */
            return TIMESTAMP_IS_NOBEGIN(dt2) ? +1 : -1;
        }
    }
 
    return timestamptz_cmp_internal(dt1, dt2);
}

References date2timestamptz_safe(), ErrorSaveContext::error_occurred, fb(), TIMESTAMP_IS_NOBEGIN, TIMESTAMP_IS_NOEND, and timestamptz_cmp_internal.

Referenced by cmpDateToTimestampTz(), date_cmp_timestamptz(), date_eq_timestamptz(), date_ge_timestamptz(), date_gt_timestamptz(), date_le_timestamptz(), date_lt_timestamptz(), date_ne_timestamptz(), timestamptz_cmp_date(), timestamptz_eq_date(), timestamptz_ge_date(), timestamptz_gt_date(), timestamptz_le_date(), timestamptz_lt_date(), and timestamptz_ne_date().

DateADTGetDatum()

static Datum DateADTGetDatum ( DateADT  X )

inlinestatic

Definition at line 78 of file date.h.

{
    return Int32GetDatum(X);
}

References fb(), and Int32GetDatum().

Referenced by cvt_timestamp_date(), cvt_timestamptz_date(), date_decrement(), date_increment(), date_skipsupport(), daterange_canonical(), ExecEvalSQLValueFunction(), gbt_date_penalty(), gbt_date_ssup_cmp(), gbt_dateeq(), gbt_datege(), gbt_dategt(), gbt_datekey_cmp(), gbt_datele(), gbt_datelt(), gbt_num_fetch(), gdb_date_dist(), leftmostvalue_date(), and parse_datetime().

DatumGetDateADT()

static DateADT DatumGetDateADT ( Datum  X )

inlinestatic

Definition at line 60 of file date.h.

{
    return (DateADT) DatumGetInt32(X);
}

References DatumGetInt32(), and fb().

Referenced by compareDatetime(), convert_timevalue_to_scalar(), cvt_date_timestamp(), cvt_date_timestamptz(), date_decrement(), date_increment(), daterange_canonical(), executeDateTimeMethod(), gbt_num_compress(), JsonEncodeDateTime(), and map_sql_value_to_xml_value().

DatumGetTimeADT()

static TimeADT DatumGetTimeADT ( Datum  X )

inlinestatic

Definition at line 66 of file date.h.

{
    return (TimeADT) DatumGetInt64(X);
}

References DatumGetInt64(), and fb().

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

DatumGetTimeTzADTP()

static TimeTzADT * DatumGetTimeTzADTP ( Datum  X )

inlinestatic

Definition at line 72 of file date.h.

{
    return (TimeTzADT *) DatumGetPointer(X);
}

References DatumGetPointer(), and fb().

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

EncodeSpecialDate()

void EncodeSpecialDate ( DateADT  dt, char *  str  )

extern

Definition at line 297 of file date.c.

{
    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");
}

References DATE_IS_NOBEGIN, DATE_IS_NOEND, EARLY, elog, ERROR, fb(), LATE, and str.

Referenced by date_out(), and JsonEncodeDateTime().

float_time_overflows()

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

extern

Definition at line 1555 of file date.c.

{
    /* 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;
}

References fb(), HOURS_PER_DAY, MINS_PER_HOUR, SECS_PER_MINUTE, USECS_PER_DAY, and USECS_PER_SEC.

Referenced by make_time(), and make_timestamp_internal().

GetSQLCurrentDate()

DateADT GetSQLCurrentDate ( void  )

extern

Definition at line 312 of file date.c.

{
    struct pg_tm tm;
 
    static int  cache_year = 0;
    static int  cache_mon = 0;
    static int  cache_mday = 0;
    static DateADT cache_date;
 
    GetCurrentDateTime(&tm);
 
    /*
     * date2j involves several integer divisions; moreover, unless our session
     * lives across local midnight, we don't really have to do it more than
     * once.  So it seems worth having a separate cache here.
     */
    if (tm.tm_year != cache_year ||
        tm.tm_mon != cache_mon ||
        tm.tm_mday != cache_mday)
    {
        cache_date = date2j(tm.tm_year, tm.tm_mon, tm.tm_mday) - POSTGRES_EPOCH_JDATE;
        cache_year = tm.tm_year;
        cache_mon = tm.tm_mon;
        cache_mday = tm.tm_mday;
    }
 
    return cache_date;
}

References date2j(), fb(), GetCurrentDateTime(), POSTGRES_EPOCH_JDATE, tm, pg_tm::tm_mday, pg_tm::tm_mon, and pg_tm::tm_year.

Referenced by ExecEvalSQLValueFunction().

GetSQLCurrentTime()

TimeTzADT * GetSQLCurrentTime ( int32  typmod )

extern

Definition at line 345 of file date.c.

{
    TimeTzADT  *result;
    struct pg_tm tt,
               *tm = &tt;
    fsec_t      fsec;
    int         tz;
 
    GetCurrentTimeUsec(tm, &fsec, &tz);
 
    result = palloc_object(TimeTzADT);
    tm2timetz(tm, fsec, tz, result);
    AdjustTimeForTypmod(&(result->time), typmod);
    return result;
}

References AdjustTimeForTypmod(), fb(), GetCurrentTimeUsec(), palloc_object, result, tm, and tm2timetz().

Referenced by ExecEvalSQLValueFunction().

GetSQLLocalTime()

TimeADT GetSQLLocalTime ( int32  typmod )

extern

Definition at line 365 of file date.c.

{
    TimeADT     result;
    struct pg_tm tt,
               *tm = &tt;
    fsec_t      fsec;
    int         tz;
 
    GetCurrentTimeUsec(tm, &fsec, &tz);
 
    tm2time(tm, fsec, &result);
    AdjustTimeForTypmod(&result, typmod);
    return result;
}

References AdjustTimeForTypmod(), fb(), GetCurrentTimeUsec(), result, tm, and tm2time().

Referenced by ExecEvalSQLValueFunction().

time2tm()

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

extern

Definition at line 1593 of file date.c.

{
    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;
}

References tm, 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_common(), and time_timetz().

time_overflows()

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

extern

Definition at line 1530 of file date.c.

{
    /* 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;
}

References fb(), HOURS_PER_DAY, MINS_PER_HOUR, SECS_PER_MINUTE, USECS_PER_DAY, and USECS_PER_SEC.

Referenced by DecodeDateTime(), and DecodeTimeOnly().

TimeADTGetDatum()

static Datum TimeADTGetDatum ( TimeADT  X )

inlinestatic

Definition at line 84 of file date.h.

{
    return Int64GetDatum(X);
}

References fb(), and Int64GetDatum().

Referenced by ExecEvalSQLValueFunction(), executeDateTimeMethod(), gbt_num_fetch(), gbt_time_dist(), gbt_time_penalty(), gbt_timeeq(), gbt_timege(), gbt_timegt(), gbt_timekey_cmp(), gbt_timekey_ssup_cmp(), gbt_timele(), gbt_timelt(), leftmostvalue_time(), and parse_datetime().

timestamp2date_safe()

DateADT timestamp2date_safe ( Timestamp  timestamp, Node *  escontext  )

extern

Definition at line 1356 of file date.c.

{
    DateADT     result;
    struct pg_tm tt,
               *tm = &tt;
    fsec_t      fsec;
 
    if (TIMESTAMP_IS_NOBEGIN(timestamp))
        DATE_NOBEGIN(result);
    else if (TIMESTAMP_IS_NOEND(timestamp))
        DATE_NOEND(result);
    else
    {
        if (timestamp2tm(timestamp, NULL, tm, &fsec, NULL, NULL) != 0)
        {
            if (timestamp < 0)
                DATE_NOBEGIN(result);
            else
                DATE_NOEND(result); /* not actually reachable */
 
            ereturn(escontext, result,
                    (errcode(ERRCODE_DATETIME_VALUE_OUT_OF_RANGE),
                     errmsg("timestamp out of range")));
        }
 
        result = date2j(tm->tm_year, tm->tm_mon, tm->tm_mday) - POSTGRES_EPOCH_JDATE;
    }
 
    return result;
}

References date2j(), DATE_NOBEGIN, DATE_NOEND, ereturn, errcode(), errmsg, fb(), POSTGRES_EPOCH_JDATE, result, timestamp2tm(), TIMESTAMP_IS_NOBEGIN, TIMESTAMP_IS_NOEND, tm, pg_tm::tm_mday, pg_tm::tm_mon, and pg_tm::tm_year.

Referenced by cvt_timestamp_date(), and timestamp_date().

timestamptz2date_safe()

DateADT timestamptz2date_safe ( TimestampTz  timestamp, Node *  escontext  )

extern

Definition at line 1437 of file date.c.

{
    DateADT     result;
    struct pg_tm tt,
               *tm = &tt;
    fsec_t      fsec;
    int         tz;
 
    if (TIMESTAMP_IS_NOBEGIN(timestamp))
        DATE_NOBEGIN(result);
    else if (TIMESTAMP_IS_NOEND(timestamp))
        DATE_NOEND(result);
    else
    {
        if (timestamp2tm(timestamp, &tz, tm, &fsec, NULL, NULL) != 0)
        {
            if (timestamp < 0)
                DATE_NOBEGIN(result);
            else
                DATE_NOEND(result); /* not actually reachable */
 
            ereturn(escontext, result,
                    (errcode(ERRCODE_DATETIME_VALUE_OUT_OF_RANGE),
                     errmsg("timestamp out of range")));
        }
 
        result = date2j(tm->tm_year, tm->tm_mon, tm->tm_mday) - POSTGRES_EPOCH_JDATE;
    }
 
    return result;
}

References date2j(), DATE_NOBEGIN, DATE_NOEND, ereturn, errcode(), errmsg, fb(), POSTGRES_EPOCH_JDATE, result, timestamp2tm(), TIMESTAMP_IS_NOBEGIN, TIMESTAMP_IS_NOEND, tm, pg_tm::tm_mday, pg_tm::tm_mon, and pg_tm::tm_year.

Referenced by cvt_timestamptz_date(), and timestamptz_date().

timetz2tm()

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

extern

Definition at line 2523 of file date.c.

{
    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;
}

References fb(), TimeTzADT::time, tm, 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_common().

TimeTzADTPGetDatum()

static Datum TimeTzADTPGetDatum ( const TimeTzADT *  X )

inlinestatic

Definition at line 90 of file date.h.

{
    return PointerGetDatum(X);
}

References fb(), and PointerGetDatum.

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

tm2time()

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

extern

Definition at line 1518 of file date.c.

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

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

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

tm2timetz()

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

extern

Definition at line 2382 of file date.c.

{
    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;
}

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

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