pgtypes_timestamp.h File Reference

#include <pgtypes.h>
#include <pgtypes_interval.h>

Include dependency graph for pgtypes_timestamp.h:

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

Go to the source code of this file.

Typedefs
typedef int64	timestamp
typedef int64	TimestampTz

Functions
timestamp	PGTYPEStimestamp_from_asc (char *str, char **endptr)
char *	PGTYPEStimestamp_to_asc (timestamp tstamp)
int	PGTYPEStimestamp_sub (timestamp *ts1, timestamp *ts2, interval *iv)
int	PGTYPEStimestamp_fmt_asc (timestamp *ts, char *output, int str_len, const char *fmtstr)
void	PGTYPEStimestamp_current (timestamp *ts)
int	PGTYPEStimestamp_defmt_asc (const char *str, const char *fmt, timestamp *d)
int	PGTYPEStimestamp_add_interval (timestamp *tin, interval *span, timestamp *tout)
int	PGTYPEStimestamp_sub_interval (timestamp *tin, interval *span, timestamp *tout)

Typedef Documentation

timestamp

typedef int64 timestamp

Definition at line 10 of file pgtypes_timestamp.h.

TimestampTz

typedef int64 TimestampTz

Definition at line 11 of file pgtypes_timestamp.h.

Function Documentation

PGTYPEStimestamp_add_interval()

int PGTYPEStimestamp_add_interval ( timestamp *  tin, interval *  span, timestamp *  tout  )

extern

Definition at line 858 of file timestamp.c.

{
    if (TIMESTAMP_NOT_FINITE(*tin))
        *tout = *tin;
    else
    {
        if (span->month != 0)
        {
            struct tm   tt,
                       *tm = &tt;
            fsec_t      fsec;
 
            if (timestamp2tm(*tin, NULL, tm, &fsec, NULL) != 0)
                return -1;
            tm->tm_mon += span->month;
            if (tm->tm_mon > MONTHS_PER_YEAR)
            {
                tm->tm_year += (tm->tm_mon - 1) / MONTHS_PER_YEAR;
                tm->tm_mon = (tm->tm_mon - 1) % MONTHS_PER_YEAR + 1;
            }
            else if (tm->tm_mon < 1)
            {
                tm->tm_year += tm->tm_mon / MONTHS_PER_YEAR - 1;
                tm->tm_mon = tm->tm_mon % MONTHS_PER_YEAR + MONTHS_PER_YEAR;
            }
 
 
            /* adjust for end of month boundary problems... */
            if (tm->tm_mday > day_tab[isleap(tm->tm_year)][tm->tm_mon - 1])
                tm->tm_mday = (day_tab[isleap(tm->tm_year)][tm->tm_mon - 1]);
 
 
            if (tm2timestamp(tm, fsec, NULL, tin) != 0)
                return -1;
        }
 
        *tin += span->time;
        *tout = *tin;
    }
 
    return 0;
}

References day_tab, fb(), isleap, MONTHS_PER_YEAR, timestamp2tm(), TIMESTAMP_NOT_FINITE, tm, tm2timestamp(), pg_tm::tm_mday, pg_tm::tm_mon, and pg_tm::tm_year.

Referenced by main(), and PGTYPEStimestamp_sub_interval().

PGTYPEStimestamp_current()

void PGTYPEStimestamp_current ( timestamp *  ts )

extern

Definition at line 290 of file timestamp.c.

{
    struct tm   tm;
 
    GetCurrentDateTime(&tm);
    if (errno == 0)
        tm2timestamp(&tm, 0, NULL, ts);
}

References fb(), GetCurrentDateTime(), tm, and tm2timestamp().

Referenced by dtcurrent(), and main().

PGTYPEStimestamp_defmt_asc()

int PGTYPEStimestamp_defmt_asc ( const char *  str, const char *  fmt, timestamp *  d  )

extern

Definition at line 806 of file timestamp.c.

{
    int         year,
                month,
                day;
    int         hour,
                minute,
                second;
    int         tz;
 
    int         i;
    char       *mstr;
    char       *mfmt;
 
    if (!fmt)
        fmt = "%Y-%m-%d %H:%M:%S";
    if (!fmt[0])
        return 1;
 
    mstr = pgtypes_strdup(str);
    mfmt = pgtypes_strdup(fmt);
 
    /*
     * initialize with impossible values so that we can see if the fields
     * where specified at all
     */
    /* XXX ambiguity with 1 BC for year? */
    year = -1;
    month = -1;
    day = -1;
    hour = 0;
    minute = -1;
    second = -1;
    tz = 0;
 
    i = PGTYPEStimestamp_defmt_scan(&mstr, mfmt, d, &year, &month, &day, &hour, &minute, &second, &tz);
    free(mstr);
    free(mfmt);
    return i;
}

References fb(), free, i, pgtypes_strdup(), PGTYPEStimestamp_defmt_scan(), and str.

Referenced by dtcvfmtasc(), and main().

PGTYPEStimestamp_fmt_asc()

int PGTYPEStimestamp_fmt_asc ( timestamp *  ts, char *  output, int  str_len, const char *  fmtstr  )

extern

Definition at line 778 of file timestamp.c.

{
    struct tm   tm;
    fsec_t      fsec;
    date        dDate;
    int         dow;
 
    dDate = PGTYPESdate_from_timestamp(*ts);
    dow = PGTYPESdate_dayofweek(dDate);
    timestamp2tm(*ts, NULL, &tm, &fsec, NULL);
 
    return dttofmtasc_replace(ts, dDate, dow, &tm, output, &str_len, fmtstr);
}

References dttofmtasc_replace(), fb(), fmtstr(), output, PGTYPESdate_dayofweek(), PGTYPESdate_from_timestamp(), timestamp2tm(), and tm.

Referenced by dttofmtasc(), and main().

PGTYPEStimestamp_from_asc()

timestamp PGTYPEStimestamp_from_asc ( char *  str, char **  endptr  )

extern

Definition at line 202 of file timestamp.c.

{
    timestamp   result;
    int64       noresult = 0;
    fsec_t      fsec;
    struct tm   tt,
               *tm = &tt;
    int         dtype;
    int         nf;
    char       *field[MAXDATEFIELDS];
    int         ftype[MAXDATEFIELDS];
    char        lowstr[MAXDATELEN + MAXDATEFIELDS];
    char       *realptr;
    char      **ptr = (endptr != NULL) ? endptr : &realptr;
 
    if (strlen(str) > MAXDATELEN)
    {
        errno = PGTYPES_TS_BAD_TIMESTAMP;
        return noresult;
    }
 
    if (ParseDateTime(str, lowstr, field, ftype, &nf, ptr) != 0 ||
        DecodeDateTime(field, ftype, nf, &dtype, tm, &fsec, 0) != 0)
    {
        errno = PGTYPES_TS_BAD_TIMESTAMP;
        return noresult;
    }
 
    switch (dtype)
    {
        case DTK_DATE:
            if (tm2timestamp(tm, fsec, NULL, &result) != 0)
            {
                errno = PGTYPES_TS_BAD_TIMESTAMP;
                return noresult;
            }
            break;
 
        case DTK_EPOCH:
            result = SetEpochTimestamp();
            break;
 
        case DTK_LATE:
            TIMESTAMP_NOEND(result);
            break;
 
        case DTK_EARLY:
            TIMESTAMP_NOBEGIN(result);
            break;
 
        default:
            errno = PGTYPES_TS_BAD_TIMESTAMP;
            return noresult;
    }
 
    /* AdjustTimestampForTypmod(&result, typmod); */
 
    /*
     * Since it's difficult to test for noresult, make sure errno is 0 if no
     * error occurred.
     */
    errno = 0;
    return result;
}

References DecodeDateTime(), DTK_DATE, DTK_EARLY, DTK_EPOCH, DTK_LATE, fb(), MAXDATEFIELDS, MAXDATELEN, ParseDateTime(), PGTYPES_TS_BAD_TIMESTAMP, SetEpochTimestamp(), str, TIMESTAMP_NOBEGIN, TIMESTAMP_NOEND, tm, and tm2timestamp().

Referenced by dtcvasc(), ecpg_get_data(), and main().

PGTYPEStimestamp_sub()

int PGTYPEStimestamp_sub ( timestamp *  ts1, timestamp *  ts2, interval *  iv  )

extern

Definition at line 793 of file timestamp.c.

{
    if (TIMESTAMP_NOT_FINITE(*ts1) || TIMESTAMP_NOT_FINITE(*ts2))
        return PGTYPES_TS_ERR_EINFTIME;
    else
        iv->time = (*ts1 - *ts2);
 
    iv->month = 0;
 
    return 0;
}

References fb(), interval::month, PGTYPES_TS_ERR_EINFTIME, interval::time, and TIMESTAMP_NOT_FINITE.

Referenced by dtsub().

PGTYPEStimestamp_sub_interval()

int PGTYPEStimestamp_sub_interval ( timestamp *  tin, interval *  span, timestamp *  tout  )

extern

Definition at line 913 of file timestamp.c.

{
    interval    tspan;
 
    tspan.month = -span->month;
    tspan.time = -span->time;
 
    return PGTYPEStimestamp_add_interval(tin, &tspan, tout);
}

References fb(), interval::month, and PGTYPEStimestamp_add_interval().

PGTYPEStimestamp_to_asc()

char * PGTYPEStimestamp_to_asc ( timestamp  tstamp )

extern

Definition at line 268 of file timestamp.c.

{
    struct tm   tt,
               *tm = &tt;
    char        buf[MAXDATELEN + 1];
    fsec_t      fsec;
    int         DateStyle = 1;  /* this defaults to USE_ISO_DATES, shall we
                                 * make it an option? */
 
    if (TIMESTAMP_NOT_FINITE(tstamp))
        EncodeSpecialTimestamp(tstamp, buf);
    else if (timestamp2tm(tstamp, NULL, tm, &fsec, NULL) == 0)
        EncodeDateTime(tm, fsec, false, 0, NULL, DateStyle, buf, 0);
    else
    {
        errno = PGTYPES_TS_BAD_TIMESTAMP;
        return NULL;
    }
    return pgtypes_strdup(buf);
}

References buf, DateStyle, EncodeDateTime(), EncodeSpecialTimestamp(), fb(), MAXDATELEN, pgtypes_strdup(), PGTYPES_TS_BAD_TIMESTAMP, timestamp2tm(), TIMESTAMP_NOT_FINITE, and tm.

Referenced by dttoasc(), ecpg_store_input(), and main().