MySQL 9.0.0
Source Code Documentation
item_timefunc.h File Reference
#include <assert.h>
#include <sys/types.h>
#include <algorithm>
#include <cstddef>
#include "field_types.h"
#include "my_inttypes.h"
#include "my_table_map.h"
#include "my_time.h"
#include "mysql/strings/m_ctype.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

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