2
{ $col = 1 ; return "" }
11
select_item , select_list |
12
select_item , select_item ;
15
_field AS { 'c'.$col++ } |
16
datetime_expr AS { 'c'.$col++ } ;
20
where_item and_or where_list ;
23
_field not IN ( datetime_list ) |
24
_field not BETWEEN datetime_expr AND datetime_expr |
25
_field comp_op datetime_expr |
26
datetime_expr IS not NULL ;
35
HAVING datetime_expr ;
42
= | < | > | != | <> | <=> | >= | <= ;
51
datetime_expr , datetime_expr |
52
datetime_expr , datetime_list ;
55
datetime_func | datetime_field ;
58
arg_datetime , arg_datetime |
59
arg_datetime , arg_datetime_list ;
62
arg_datetime | arg_datetime | arg_datetime | arg_datetime | arg_date | datetime_func | '0000-00-00 00:00:00' | datetime_field ;
65
_date | _date | _date | _date | '0000-00-00' | datetime_func | datetime_field ;
68
_time | _time | _time | _time | '00:00:00' | datetime_func | datetime_field ;
72
arg_any , arg_any_list ;
77
arg_date | datetime_func | datetime_field ;
80
_tinyint_unsigned | digit | integer_func | integer_field ;
96
'leap/Europe/Moscow' |
98
CONCAT( plus_minus , CONCAT_WS(':', _digit , _digit ) ) ;
101
_digit | 24 | _tinyint_unsigned | integer_func | 24 ;
104
_digit | _tinyint_unsigned | integer_func | 60 ;
107
_digit | _digit | _digit | _tinyint_unsigned | integer_func ;
110
_tinyint_unsigned | _tinyint_unsigned | _tinyint_unsigned | integer_func ;
113
19 + _digit | 20 + _digit | _tinyint_unsigned | integer_func | '0000';
119
DATE_FORMAT( arg_any , arg_format ) ;
125
LEAST( arg_any_list ) |
126
GREATEST( arg_any_list ) |
127
COALESCE( arg_any_list ) |
128
CAST( arg_any AS arg_cast_type ) |
130
ADDDATE( arg_datetime , arg_days ) |
131
ADDTIME( arg_any , arg_time ) |
132
CONVERT_TZ( arg_datetime , arg_tz , arg_tz ) |
133
CURDATE() | CURRENT_DATE() |
134
# CURTIME() | CURRENT_TIME() |
135
# CURRENT_TIMESTAMP() | NOW() |
136
DATE( arg_date ) | DATE ( arg_datetime ) |
137
FROM_DAYS( arg_integer ) |
138
FROM_UNIXTIME( arg_unix ) | FROM_UNIXTIME( arg_unix , arg_format ) |
139
LAST_DAY( arg_datetime ) |
140
LOCALTIME() | LOCALTIMESTAMP() |
141
MAKEDATE( arg_year , arg_dayofyear ) |
142
MAKETIME( arg_hour , arg_minute, arg_second ) |
144
SEC_TO_TIME( arg_second ) |
145
STR_TO_DATE( arg_formatted , arg_format ) |
148
TIMEDIFF( arg_any , arg_any ) |
149
TIMESTAMP( arg_any ) | TIMESTAMP( arg_any , arg_time ) |
150
TIMESTAMPADD( arg_unit_timestamp , arg_integer , arg_datetime ) |
152
# UNIX_TIMESTAMP( arg_datetime ) |
154
# UTC_TIME() | UTC_TIMESTAMP() |
155
SUBTIME( arg_datetime , arg_time ) |
156
EXTRACT( arg_unit_noninteger FROM arg_any ) ;
159
DATEDIFF( arg_date , arg_date ) | DATEDIFF( arg_datetime , arg_datetime ) |
160
DAY( arg_date ) | DAYOFMONTH( arg_date ) ;
161
DAYOFMONTH( arg_datetime ) |
162
DAYOFWEEK( arg_datetime ) |
163
DAYOFYEAR( arg_datetime ) |
164
EXTRACT( arg_unit_integer FROM arg_any ) |
165
HOUR( arg_datetime ) |
166
MICROSECOND( arg_any ) |
169
PERIOD_ADD( arg_period , arg_integer ) |
170
PERIOD_DIFF( arg_period , arg_period ) |
171
QUARTER( arg_date ) |
173
TIMESTAMPDIFF( arg_interval , arg_datetime , arg_datetime ) |
174
TIME_TO_SEC( arg_any ) |
175
TO_DAYS( arg_datetime ) |
176
TO_SECONDS( arg_datetime ) |
177
WEEK( arg_datetime , arg_mode ) |
178
WEEKDAY( arg_datetime ) |
179
WEEKOFYEAR( arg_datetime ) |
180
YEAR( arg_datetime ) ;
181
YEARWEEK( arg_datetime ) | YEARWEEK( arg_datetime , arg_mode ) |
183
IF( integer_func , datetime_func , datetime_func ) |
184
IFNULL( datetime_func ) |
185
NULLFIF( datetime_func, datetime_func ) |
186
INTERVAL ( arg_datetime_list ) ;
190
DATE_FORMAT( arg_any , arg_format ) |
191
DAYNAME( arg_date ) ;
192
MONTHNAME( arg_date ) |
193
TIME_FORMAT( arg_time , arg_time_format ) |
196
SUBDATE( arg_date , INTERVAL arg_expr arg_unit ) |
197
SUBDATE( arg_date , arg_days ) |
201
add_sub arg_datetime arg_integer , arg_unit_integer ) |
202
add_sub arg_datetime , INTERVAL CONCAT_WS('.' , arg_second , arg_microsecond ) SECOND_MICROSECOND ) |
203
add_sub arg_datetime , INTERVAL CONCAT_WS('.' , CONCAT_WS(':' , arg_minute , arg_second ) , arg_microsecond ) MINUTE_MICROSECOND ) |
204
add_sub arg_datetime , INTERVAL CONCAT_WS(':' , arg_minute , arg_second ) MINUTE_SECOND ) |
205
add_sub arg_datetime , INTERVAL CONCAT_WS('.' , CONCAT_WS(':' , arg_hour , arg_minute, arg_second ) , arg_microsecond ) HOUR_MICROSECOND ) |
206
add_sub arg_datetime , INTERVAL CONCAT_WS(':' , arg_hour , arg_minute, arg_second ) HOUR_SECOND ) |
207
add_sub arg_datetime , INTERVAL CONCAT_WS(':' , arg_hour , arg_minute ) HOUR_MINUTE ) |
208
add_sub arg_datetime , INTERVAL CONCAT_WS(' ' , arg_day , CONCAT_WS(':' , arg_hour , arg_minute, CONCAT_WS('.' , arg_second , arg_microsecond ) DAY_MICROSECOND ) |
209
add_sub arg_datetime , INTERVAL CONCAT_WS(' ' , arg_day , CONCAT_WS(':' , arg_hour , arg_minute , arg_second ) DAY_SECOND ) |
210
add_sub arg_datetime , INTERVAL CONCAT_WS(' ' , arg_day , CONCAT_WS(':' , arg_hour , arg_minute ) DAY_MINUTE ) |
211
add_sub arg_datetime , INTERVAL CONCAT_WS(' ' , arg_day , arg_hours ) DAY_HOUR ) |
212
add_sub arg_datetime , INTERVAL CONCAT_WS('-' , arg_year , arg_month ) YEAR_MONTH ) ;
216
SECOND | MINUTE | HOUR | DAY | WEEK | MONTH | QUARTER | YEAR ;
219
SECOND_MICROSECOND | MINUTE_MICROSECOND | MINUTE_SECOND | HOUR_MICROSECOND | HOUR_SECOND | HOUR_MINUTE | DAY_MICROSECOND | DAY_SECOND | DAY_MINUTE | DAY_HOUR | YEAR_MONTH ;
223
SECOND | MINUTE | HOUR | DAY | WEEK | MONTH | QUARTER | YEAR | SECOND_MICROSECOND | MINUTE_MICROSECOND | MINUTE_SECOND | HOUR_MICROSECOND | HOUR_SECOND | HOUR_MINUTE | DAY_MICROSECOND | DAY_SECOND | DAY_MINUTE | DAY_HOUR | YEAR_MONTH ;
227
SECOND | MINUTE | HOUR | DAY | WEEK | MONTH | QUARTER | YEAR ;
230
DATE_ADD( | DATE_SUB( | SUBDATE
233
0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 ;
236
DATE | DATETIME | TIME | DATETIME( precision ) | TIME | TIME( precision ) ;
242
GET_FORMAT( date_time_datetime , country_code ) ;
245
DATE | TIME | DATETIME ;
248
EUR | USA | JIS | ISO | INTERNAL ;
252
CONCAT_WS( format_separator , format_list );
255
format_item , format_item |
256
format_item , format_list ;
259
'%a' | '%b' | '%c' | '%D' | '%d' | '%e' | '%f' | '%H' | '%h' | '%I' | '%i' | '%j' | '%k' | '%l' | '%M' | '%m' | '%p' | '%r' | '%S' | '%s' | '%T' | '%U' | '%u' | '%V' | '%v' | '%W' | '%w' | '%X' | '%x' | '%Y' | '%y' | '%%' | '%x' ;