compat.c File Reference

#include "postgres.h"
#include <time.h>
#include "utils/datetime.h"

Include dependency graph for compat.c:

Go to the source code of this file.

Macros
#define	FRONTEND   1

Functions
pg_time_t	timestamptz_to_time_t (TimestampTz t)
const char *	timestamptz_to_str (TimestampTz t)

Macro Definition Documentation

FRONTEND

#define FRONTEND   1

Definition at line 18 of file compat.c.

Function Documentation

timestamptz_to_str()

const char* timestamptz_to_str

(

TimestampTz

t

)

Definition at line 49 of file compat.c.

{
    static char buf[MAXDATELEN + 1];
    char        ts[MAXDATELEN + 1];
    char        zone[MAXDATELEN + 1];
    time_t      result = (time_t) timestamptz_to_time_t(t);
    struct tm  *ltime = localtime(&result);
 
    strftime(ts, sizeof(ts), "%Y-%m-%d %H:%M:%S", ltime);
    strftime(zone, sizeof(zone), "%Z", ltime);
 
    snprintf(buf, sizeof(buf), "%s.%06d %s",
             ts, (int) (t % USECS_PER_SEC), zone);
 
    return buf;
}

References buf, MAXDATELEN, snprintf, timestamptz_to_time_t(), tm, and USECS_PER_SEC.

timestamptz_to_time_t()

pg_time_t timestamptz_to_time_t

(

TimestampTz

t

)

Definition at line 27 of file compat.c.

{
    pg_time_t   result;
 
    result = (pg_time_t) (t / USECS_PER_SEC +
                          ((POSTGRES_EPOCH_JDATE - UNIX_EPOCH_JDATE) * SECS_PER_DAY));
    return result;
}

References POSTGRES_EPOCH_JDATE, SECS_PER_DAY, UNIX_EPOCH_JDATE, and USECS_PER_SEC.

Referenced by timestamptz_to_str().