File db_date.h¶

FileList > compat > db_date.h

#include "dbtype_def.h"
#include <time.h>

Public Functions¶

Type	Name
int	day_of_week (int jul_day)
int	db_add_int_to_datetime (DB_DATETIME * datetime, DB_BIGINT i2, DB_DATETIME * result_datetime)
int	db_add_weeks_and_days_to_date (int * day, int * month, int * year, int weeks, int day_week)
int	db_check_time_date_format (const char * format_s)
int	db_date_parse_date (char const * str, int str_len, DB_DATE * date)
int	db_date_parse_datetime (char const * str, int str_len, DB_DATETIME * datetime)
int	db_date_parse_datetime_parts (char const * str, int str_len, DB_DATETIME * date, bool * is_explicit_time, bool * has_explicit_msec, bool * fits_as_timestamp, char const ** endp)
int	db_date_parse_time (char const * str, int str_len, DB_TIME * time, int * milisec)
int	db_date_parse_timestamp (char const * str, int str_len, DB_TIMESTAMP * utime)
int	db_date_to_string (char * buf, int bufsize, DB_DATE * date)
int	db_date_weekday (DB_DATE * date)
int	db_datetime_decode (const DB_DATETIME * datetime, int * month, int * day, int * year, int * hour, int * minute, int * second, int * millisecond)
int	db_datetime_encode (DB_DATETIME * datetime, int month, int day, int year, int hour, int minute, int second, int millisecond)
int	db_datetime_to_string (char * buf, int bufsize, DB_DATETIME * datetime)
int	db_datetime_to_string2 (char * buf, int bufsize, DB_DATETIME * datetime)
int	db_datetimeltz_to_string (char * buf, int bufsize, DB_DATETIME * dt)
int	db_datetimetz_to_string (char * buf, int bufsize, DB_DATETIME * dt, const TZ_ID * tz_id)
int	db_get_day_of_week (int year, int month, int day)
int	db_get_day_of_year (int year, int month, int day)
int	db_get_week_of_year (int year, int month, int day, int mode)
void	db_localdatetime (time_t * epoch_time, DB_DATETIME * datetime)
void	db_localdatetime_msec (time_t * epoch_time, int millisecond, DB_DATETIME * datetime)
void	db_localtime (time_t * epoch_time, DB_DATE * date, DB_TIME * timeval)
time_t	db_mktime (DB_DATE * date, DB_TIME * timeval)
int	db_strftime (char * s, int smax, const char * fmt, DB_DATE * date, DB_TIME * timeval)
bool	db_string_check_explicit_date (const char * str, int str_len)
bool	db_string_check_explicit_time (const char * str, int str_len)
int	db_string_to_date (const char * buf, DB_DATE * date)
int	db_string_to_date_ex (const char * buf, int str_len, DB_DATE * date)
int	db_string_to_datetime (const char * str, DB_DATETIME * datetime)
int	db_string_to_datetime_ex (const char * str, int str_len, DB_DATETIME * datetime)
int	db_string_to_datetimeltz (const char * str, DB_DATETIME * datetime)
int	db_string_to_datetimeltz_ex (const char * str, int str_len, DB_DATETIME * datetime)
int	db_string_to_datetimetz (const char * str, DB_DATETIMETZ * dt_tz, bool * has_zone)
int	db_string_to_datetimetz_ex (const char * str, int str_len, DB_DATETIMETZ * dt_tz, bool * has_zone)
int	db_string_to_time (const char * buf, DB_TIME * dbtime)
int	db_string_to_time_ex (const char * buf, int buf_len, DB_TIME * dbtime)
int	db_string_to_timestamp (const char * buf, DB_TIMESTAMP * utime)
int	db_string_to_timestamp_ex (const char * buf, int buf_len, DB_TIMESTAMP * utime)
int	db_string_to_timestampltz (const char * str, DB_TIMESTAMP * ts)
int	db_string_to_timestampltz_ex (const char * str, int str_len, DB_TIMESTAMP * ts)
int	db_string_to_timestamptz (const char * str, DB_TIMESTAMPTZ * ts_tz, bool * has_zone)
int	db_string_to_timestamptz_ex (const char * str, int str_len, DB_TIMESTAMPTZ * ts_tz, bool * has_zone, bool is_cast)
int	db_subtract_int_from_datetime (DB_DATETIME * dt1, DB_BIGINT i2, DB_DATETIME * result_datetime)
int	db_time_to_string (char * buf, int bufsize, DB_TIME * dbtime)
int	db_timestamp_decode_ses (const DB_TIMESTAMP * utime, DB_DATE * date, DB_TIME * timeval)
void	db_timestamp_decode_utc (const DB_TIMESTAMP * utime, DB_DATE * date, DB_TIME * timeval)
int	db_timestamp_decode_w_reg (const DB_TIMESTAMP * utime, const TZ_REGION * tz_region, DB_DATE * date, DB_TIME * timeval)
int	db_timestamp_decode_w_tz_id (const DB_TIMESTAMP * utime, const TZ_ID * tz_id, DB_DATE * date, DB_TIME * timeval)
int	db_timestamp_encode (DB_TIMESTAMP * utime, DB_DATE * date, DB_TIME * timeval)
int	db_timestamp_encode_ses (const DB_DATE * date, const DB_TIME * timeval, DB_TIMESTAMP * utime, TZ_ID * dest_tz_id)
int	db_timestamp_encode_sys (const DB_DATE * date, const DB_TIME * timeval, DB_TIMESTAMP * utime, TZ_ID * dest_tz_id)
int	db_timestamp_encode_utc (const DB_DATE * date, const DB_TIME * timeval, DB_TIMESTAMP * utime)
int	db_timestamp_to_string (char * buf, int bufsize, DB_TIMESTAMP * utime)
int	db_timestampltz_to_string (char * buf, int bufsize, DB_TIMESTAMP * utime)
int	db_timestamptz_to_string (char * buf, int bufsize, DB_TIMESTAMP * utime, const TZ_ID * tz_id)
int	db_tm_encode (struct tm * c_time_struct, DB_DATE * date, DB_TIME * timeval)
bool	is_leap_year (int year)
void	julian_decode (int jul, int * monthp, int * dayp, int * yearp, int * weekp)
int	julian_encode (int m, int d, int y)

Public Functions Documentation¶

function day_of_week¶

int day_of_week (
    int jul_day
)

function db_add_int_to_datetime¶

int db_add_int_to_datetime (
    DB_DATETIME * datetime,
    DB_BIGINT i2,
    DB_DATETIME * result_datetime
)

function db_add_weeks_and_days_to_date¶

int db_add_weeks_and_days_to_date (
    int * day,
    int * month,
    int * year,
    int weeks,
    int day_week
)

function db_check_time_date_format¶

int db_check_time_date_format (
    const  char * format_s
)

function db_date_parse_date¶

int db_date_parse_date (
    char  const * str,
    int str_len,
    DB_DATE * date
)

function db_date_parse_datetime¶

int db_date_parse_datetime (
    char  const * str,
    int str_len,
    DB_DATETIME * datetime
)

function db_date_parse_datetime_parts¶

int db_date_parse_datetime_parts (
    char  const * str,
    int str_len,
    DB_DATETIME * date,
    bool * is_explicit_time,
    bool * has_explicit_msec,
    bool * fits_as_timestamp,
    char  const ** endp
)

function db_date_parse_time¶

int db_date_parse_time (
    char  const * str,
    int str_len,
    DB_TIME * time,
    int * milisec
)

function db_date_parse_timestamp¶

int db_date_parse_timestamp (
    char  const * str,
    int str_len,
    DB_TIMESTAMP * utime
)

function db_date_to_string¶

int db_date_to_string (
    char * buf,
    int bufsize,
    DB_DATE * date
)

function db_date_weekday¶

int db_date_weekday (
    DB_DATE * date
)

function db_datetime_decode¶

int db_datetime_decode (
    const  DB_DATETIME * datetime,
    int * month,
    int * day,
    int * year,
    int * hour,
    int * minute,
    int * second,
    int * millisecond
)

function db_datetime_encode¶

int db_datetime_encode (
    DB_DATETIME * datetime,
    int month,
    int day,
    int year,
    int hour,
    int minute,
    int second,
    int millisecond
)

function db_datetime_to_string¶

int db_datetime_to_string (
    char * buf,
    int bufsize,
    DB_DATETIME * datetime
)

function db_datetime_to_string2¶

int db_datetime_to_string2 (
    char * buf,
    int bufsize,
    DB_DATETIME * datetime
)

function db_datetimeltz_to_string¶

int db_datetimeltz_to_string (
    char * buf,
    int bufsize,
    DB_DATETIME * dt
)

function db_datetimetz_to_string¶

int db_datetimetz_to_string (
    char * buf,
    int bufsize,
    DB_DATETIME * dt,
    const  TZ_ID * tz_id
)

function db_get_day_of_week¶

int db_get_day_of_week (
    int year,
    int month,
    int day
)

function db_get_day_of_year¶

int db_get_day_of_year (
    int year,
    int month,
    int day
)

function db_get_week_of_year¶

int db_get_week_of_year (
    int year,
    int month,
    int day,
    int mode
)

function db_localdatetime¶

void db_localdatetime (
    time_t * epoch_time,
    DB_DATETIME * datetime
)

function db_localdatetime_msec¶

void db_localdatetime_msec (
    time_t * epoch_time,
    int millisecond,
    DB_DATETIME * datetime
)

function db_localtime¶

void db_localtime (
    time_t * epoch_time,
    DB_DATE * date,
    DB_TIME * timeval
)

function db_mktime¶

time_t db_mktime (
    DB_DATE * date,
    DB_TIME * timeval
)

function db_strftime¶

int db_strftime (
    char * s,
    int smax,
    const  char * fmt,
    DB_DATE * date,
    DB_TIME * timeval
)

function db_string_check_explicit_date¶

bool db_string_check_explicit_date (
    const  char * str,
    int str_len
)

function db_string_check_explicit_time¶

bool db_string_check_explicit_time (
    const  char * str,
    int str_len
)

function db_string_to_date¶

int db_string_to_date (
    const  char * buf,
    DB_DATE * date
)

function db_string_to_date_ex¶

int db_string_to_date_ex (
    const  char * buf,
    int str_len,
    DB_DATE * date
)

function db_string_to_datetime¶

int db_string_to_datetime (
    const  char * str,
    DB_DATETIME * datetime
)

function db_string_to_datetime_ex¶

int db_string_to_datetime_ex (
    const  char * str,
    int str_len,
    DB_DATETIME * datetime
)

function db_string_to_datetimeltz¶

int db_string_to_datetimeltz (
    const  char * str,
    DB_DATETIME * datetime
)

function db_string_to_datetimeltz_ex¶

int db_string_to_datetimeltz_ex (
    const  char * str,
    int str_len,
    DB_DATETIME * datetime
)

function db_string_to_datetimetz¶

int db_string_to_datetimetz (
    const  char * str,
    DB_DATETIMETZ * dt_tz,
    bool * has_zone
)

function db_string_to_datetimetz_ex¶

int db_string_to_datetimetz_ex (
    const  char * str,
    int str_len,
    DB_DATETIMETZ * dt_tz,
    bool * has_zone
)

function db_string_to_time¶

int db_string_to_time (
    const  char * buf,
    DB_TIME * dbtime
)

function db_string_to_time_ex¶

int db_string_to_time_ex (
    const  char * buf,
    int buf_len,
    DB_TIME * dbtime
)

function db_string_to_timestamp¶

int db_string_to_timestamp (
    const  char * buf,
    DB_TIMESTAMP * utime
)

function db_string_to_timestamp_ex¶

int db_string_to_timestamp_ex (
    const  char * buf,
    int buf_len,
    DB_TIMESTAMP * utime
)

function db_string_to_timestampltz¶

int db_string_to_timestampltz (
    const  char * str,
    DB_TIMESTAMP * ts
)

function db_string_to_timestampltz_ex¶

int db_string_to_timestampltz_ex (
    const  char * str,
    int str_len,
    DB_TIMESTAMP * ts
)

function db_string_to_timestamptz¶

int db_string_to_timestamptz (
    const  char * str,
    DB_TIMESTAMPTZ * ts_tz,
    bool * has_zone
)

function db_string_to_timestamptz_ex¶

int db_string_to_timestamptz_ex (
    const  char * str,
    int str_len,
    DB_TIMESTAMPTZ * ts_tz,
    bool * has_zone,
    bool is_cast
)

function db_subtract_int_from_datetime¶

int db_subtract_int_from_datetime (
    DB_DATETIME * dt1,
    DB_BIGINT i2,
    DB_DATETIME * result_datetime
)

function db_time_to_string¶

int db_time_to_string (
    char * buf,
    int bufsize,
    DB_TIME * dbtime
)

function db_timestamp_decode_ses¶

int db_timestamp_decode_ses (
    const  DB_TIMESTAMP * utime,
    DB_DATE * date,
    DB_TIME * timeval
)

function db_timestamp_decode_utc¶

void db_timestamp_decode_utc (
    const  DB_TIMESTAMP * utime,
    DB_DATE * date,
    DB_TIME * timeval
)

function db_timestamp_decode_w_reg¶

int db_timestamp_decode_w_reg (
    const  DB_TIMESTAMP * utime,
    const  TZ_REGION * tz_region,
    DB_DATE * date,
    DB_TIME * timeval
)

function db_timestamp_decode_w_tz_id¶

int db_timestamp_decode_w_tz_id (
    const  DB_TIMESTAMP * utime,
    const  TZ_ID * tz_id,
    DB_DATE * date,
    DB_TIME * timeval
)

function db_timestamp_encode¶

int db_timestamp_encode (
    DB_TIMESTAMP * utime,
    DB_DATE * date,
    DB_TIME * timeval
)

function db_timestamp_encode_ses¶

int db_timestamp_encode_ses (
    const  DB_DATE * date,
    const  DB_TIME * timeval,
    DB_TIMESTAMP * utime,
    TZ_ID * dest_tz_id
)

function db_timestamp_encode_sys¶

int db_timestamp_encode_sys (
    const  DB_DATE * date,
    const  DB_TIME * timeval,
    DB_TIMESTAMP * utime,
    TZ_ID * dest_tz_id
)

function db_timestamp_encode_utc¶

int db_timestamp_encode_utc (
    const  DB_DATE * date,
    const  DB_TIME * timeval,
    DB_TIMESTAMP * utime
)

function db_timestamp_to_string¶

int db_timestamp_to_string (
    char * buf,
    int bufsize,
    DB_TIMESTAMP * utime
)

function db_timestampltz_to_string¶

int db_timestampltz_to_string (
    char * buf,
    int bufsize,
    DB_TIMESTAMP * utime
)

function db_timestamptz_to_string¶

int db_timestamptz_to_string (
    char * buf,
    int bufsize,
    DB_TIMESTAMP * utime,
    const  TZ_ID * tz_id
)

function db_tm_encode¶

int db_tm_encode (
    struct  tm * c_time_struct,
    DB_DATE * date,
    DB_TIME * timeval
)

function is_leap_year¶

bool is_leap_year (
    int year
)

function julian_decode¶

void julian_decode (
    int jul,
    int * monthp,
    int * dayp,
    int * yearp,
    int * weekp
)

function julian_encode¶

int julian_encode (
    int m,
    int d,
    int y
)

The documentation for this class was generated from the following file cubrid/src/compat/db_date.h