item_timefunc.h File Reference

#include <assert.h>
#include <sys/types.h>
#include <algorithm>
#include <cstddef>
#include "field_types.h"
#include "m_ctype.h"
#include "my_inttypes.h"
#include "my_table_map.h"
#include "my_time.h"
#include "mysql/udf_registration_types.h"
#include "mysql_time.h"
#include "sql/enum_query_type.h"
#include "sql/field.h"
#include "sql/item.h"
#include "sql/item_func.h"
#include "sql/item_strfunc.h"
#include "sql/parse_location.h"
#include "sql/set_var.h"
#include "sql/sql_const.h"
#include "sql_string.h"
#include "template_utils.h"

Go to the source code of this file.

Classes
class	Item_func_period_add
class	Item_func_period_diff
class	Item_func_to_days
class	Item_func_to_seconds
class	Item_func_dayofmonth
class	Item_func_month
	TS-TODO: This should probably have Item_int_func as parent class. More...
class	Item_func_monthname
class	Item_func_dayofyear
class	Item_func_hour
class	Item_func_minute
class	Item_func_quarter
class	Item_func_second
class	Item_func_week
class	Item_func_yearweek
class	Item_func_year
class	Item_typecast_year
class	Item_func_weekday
	TS-TODO: This should probably have Item_int_func as parent class. More...
class	Item_func_dayname
	TS-TODO: Item_func_dayname should be derived from Item_str_func. More...
class	Item_timeval_func
class	Item_func_unix_timestamp
class	Item_func_time_to_sec
class	Item_temporal_func
	Abstract class for functions returning TIME, DATE, DATETIME types whose data type is known at constructor time. More...
class	Item_temporal_hybrid_func
	Abstract class for functions returning TIME, DATE, DATETIME or string values, whose data type depends on parameters and is set at fix_field time. More...
class	Item_date_func
	Abstract class for functions returning DATE values. More...
class	Item_datetime_func
	Abstract class for functions returning DATETIME values. More...
class	Item_time_func
	Abstract class for functions returning TIME values. More...
class	MYSQL_TIME_cache
	Cache for MYSQL_TIME value with various representations. More...
class	Item_date_literal
	DATE'2010-01-01'. More...
class	Item_time_literal
	TIME'10:10:10'. More...
class	Item_datetime_literal
	TIMESTAMP'2001-01-01 10:20:30'. More...
class	Item_func_at_time_zone
	This function implements the AT TIME ZONE operator, which casts a temporal value to a temporal with time zone. More...
class	Item_func_curtime
	Abstract CURTIME function. Children should define what time zone is used. More...
class	Item_func_curtime_local
class	Item_func_curtime_utc
class	Item_func_curdate
	Abstract CURDATE function. More...
class	Item_func_curdate_local
class	Item_func_curdate_utc
class	Item_func_now
	Abstract CURRENT_TIMESTAMP function. More...
class	Item_func_now_local
class	Item_func_now_utc
class	Item_func_sysdate_local
	SYSDATE() is like NOW(), but always uses the real current time, not the query_start(). More...
class	Item_func_from_days
class	Item_func_date_format
class	Item_func_from_unixtime
class	Item_func_convert_tz
class	Item_func_sec_to_time
class	Item_date_add_interval
	Implementation class for the DATE_ADD and DATE_SUB functions. More...
class	Item_extract
class	Item_typecast_date
class	Item_typecast_time
class	Item_typecast_datetime
class	Item_func_makedate
class	Item_func_add_time
	Add a time expression to a temporal expression, or subtract a time expression from a temporal expression. More...
class	Item_func_timediff
class	Item_func_maketime
class	Item_func_microsecond
class	Item_func_timestamp_diff
class	Item_func_get_format
class	Item_func_str_to_date
class	Item_func_last_day
class	Item_func_internal_update_time
class	Item_func_internal_check_time

Enumerations
enum	date_time_format {   USA_FORMAT , JIS_FORMAT , ISO_FORMAT , EUR_FORMAT ,   INTERNAL_FORMAT }

Functions
bool	get_interval_value (Item *args, interval_type int_type, String *str_value, Interval *interval)
	Convert a string to a interval value. More...
bool	make_date_time (Date_time_format *format, MYSQL_TIME *l_time, enum_mysql_timestamp_type type, String *str)
	Create a formatted date/time value in a string. More...

Variables
const char *	interval_names []

Enumeration Type Documentation

date_time_format

enum date_time_format

Enumerator
USA_FORMAT
JIS_FORMAT
ISO_FORMAT
EUR_FORMAT
INTERNAL_FORMAT

Function Documentation

get_interval_value()

bool get_interval_value	(	Item *	args,
		interval_type	int_type,
		String *	str_value,
		Interval *	interval
	)

Convert a string to a interval value.

To make code easy, allow interval objects without separators.

make_date_time()

bool make_date_time	(	Date_time_format *	format,
		MYSQL_TIME *	l_time,
		enum_mysql_timestamp_type	type,
		String *	str
	)

Create a formatted date/time value in a string.

Variable Documentation

interval_names

const char* interval_names[]

extern