2
INSERT INTO _table ( _field ) VALUE ( datetime_expr ) |
3
INSERT INTO _table ( _field ) VALUE ( datetime_expr ) |
4
INSERT INTO _table ( _field ) VALUE ( datetime_expr ) |
5
INSERT INTO _table ( _field ) VALUE ( datetime_expr ) |
6
UPDATE _table SET _field = datetime_expr WHERE where_list |
7
DELETE FROM _table WHERE where_list ORDER BY pk LIMIT 1 ;
9
# { $col = 1 ; return "" }
18
select_item , select_list |
19
select_item , select_item ;
22
_field AS { 'c'.$col++ } |
23
datetime_expr AS { 'c'.$col++ } ;
27
where_item and_or where_list ;
30
_field not IN ( datetime_list ) |
31
# _field not BETWEEN datetime_expr AND datetime_expr |
32
_field comp_op datetime_expr |
33
datetime_expr IS not NULL ;
42
HAVING datetime_expr ;
49
= | < | > | != | <> | <=> | >= | <= ;
58
datetime_expr , datetime_expr |
59
datetime_expr , datetime_list ;
62
datetime_func | datetime_field ;
65
arg_datetime , arg_datetime |
66
arg_datetime , arg_datetime_list ;
69
arg_datetime | arg_datetime | arg_datetime | arg_datetime | arg_date | datetime_func | '0000-00-00 00:00:00' | datetime_field ;
72
_date | _date | _date | _date | '0000-00-00' | datetime_func | datetime_field ;
75
_time | _time | _time | _time | '00:00:00' | datetime_func | datetime_field ;
79
arg_any , arg_any_list ;
82
arg_datetime | arg_time | arg_date | datetime_func | datetime_field ;
85
_tinyint_unsigned | digit | integer_func | integer_field ;
101
'leap/Europe/Moscow' |
103
CONCAT( plus_minus , CONCAT_WS(':', _digit , _digit ) ) ;
106
_digit | 24 | _tinyint_unsigned | integer_func | 24 ;
109
_digit | _tinyint_unsigned | integer_func | 60 ;
112
_digit | _digit | _digit | _tinyint_unsigned | integer_func ;
115
_tinyint_unsigned | _tinyint_unsigned | _tinyint_unsigned | integer_func ;
118
19 + _digit | 20 + _digit | _tinyint_unsigned | integer_func | '0000';
124
DATE_FORMAT( arg_any , arg_format ) ;
130
# LEAST( arg_any_list ) |
131
# GREATEST( arg_any_list ) |
132
# COALESCE( arg_any_list ) |
134
# CAST( arg_any AS arg_cast_type ) |
136
ADDDATE( arg_datetime , arg_days ) |
137
# ADDTIME( arg_any , arg_time ) |
138
CONVERT_TZ( arg_datetime , arg_tz , arg_tz ) |
139
CURDATE() | CURRENT_DATE() |
140
# CURTIME() | CURRENT_TIME() |
141
# CURRENT_TIMESTAMP() | NOW() |
142
DATE( arg_date ) | DATE ( arg_datetime ) |
143
FROM_DAYS( arg_integer ) |
144
FROM_UNIXTIME( arg_unix ) | FROM_UNIXTIME( arg_unix , arg_format ) |
145
# LAST_DAY( arg_datetime ) |
146
# LOCALTIME() | LOCALTIMESTAMP() |
147
MAKEDATE( arg_year , arg_dayofyear ) |
148
# MAKETIME( arg_hour , arg_minute, arg_second ) |
150
# SEC_TO_TIME( arg_second ) |
151
# STR_TO_DATE( arg_formatted , arg_format ) |
154
# TIMEDIFF( arg_any , arg_any ) |
155
TIMESTAMP( arg_any ) | TIMESTAMP( arg_any , arg_time ) |
156
TIMESTAMPADD( arg_unit_timestamp , arg_integer , arg_datetime ) |
158
# UNIX_TIMESTAMP( arg_datetime ) |
161
# UTC_TIME() | UTC_TIMESTAMP() |
162
# SUBTIME( arg_datetime , arg_time ) |
163
# EXTRACT( arg_unit_noninteger FROM arg_any ) ;
166
DATEDIFF( arg_date , arg_date ) | DATEDIFF( arg_datetime , arg_datetime ) |
167
DAY( arg_date ) | DAYOFMONTH( arg_date ) ;
168
DAYOFMONTH( arg_datetime ) |
169
DAYOFWEEK( arg_datetime ) |
170
DAYOFYEAR( arg_datetime ) |
171
EXTRACT( arg_unit_integer FROM arg_any ) |
172
HOUR( arg_datetime ) |
173
MICROSECOND( arg_any ) |
176
PERIOD_ADD( arg_period , arg_integer ) |
177
PERIOD_DIFF( arg_period , arg_period ) |
178
QUARTER( arg_date ) |
180
TIMESTAMPDIFF( arg_interval , arg_datetime , arg_datetime ) |
181
TIME_TO_SEC( arg_any ) |
182
TO_DAYS( arg_datetime ) |
183
TO_SECONDS( arg_datetime ) |
184
WEEK( arg_datetime , arg_mode ) |
185
WEEKDAY( arg_datetime ) |
186
WEEKOFYEAR( arg_datetime ) |
187
YEAR( arg_datetime ) ;
188
YEARWEEK( arg_datetime ) | YEARWEEK( arg_datetime , arg_mode ) |
190
IF( integer_func , datetime_func , datetime_func ) |
191
IFNULL( datetime_func ) |
192
NULLFIF( datetime_func, datetime_func ) |
193
INTERVAL ( arg_datetime_list ) ;
197
DATE_FORMAT( arg_any , arg_format ) |
198
DAYNAME( arg_date ) ;
199
MONTHNAME( arg_date ) |
200
TIME_FORMAT( arg_time , arg_time_format ) |
203
SUBDATE( arg_date , INTERVAL arg_expr arg_unit ) |
204
SUBDATE( arg_date , arg_days ) |
208
add_sub arg_datetime arg_integer , arg_unit_integer ) |
209
add_sub arg_datetime , INTERVAL CONCAT_WS('.' , arg_second , arg_microsecond ) SECOND_MICROSECOND ) |
210
add_sub arg_datetime , INTERVAL CONCAT_WS('.' , CONCAT_WS(':' , arg_minute , arg_second ) , arg_microsecond ) MINUTE_MICROSECOND ) |
211
add_sub arg_datetime , INTERVAL CONCAT_WS(':' , arg_minute , arg_second ) MINUTE_SECOND ) |
212
add_sub arg_datetime , INTERVAL CONCAT_WS('.' , CONCAT_WS(':' , arg_hour , arg_minute, arg_second ) , arg_microsecond ) HOUR_MICROSECOND ) |
213
add_sub arg_datetime , INTERVAL CONCAT_WS(':' , arg_hour , arg_minute, arg_second ) HOUR_SECOND ) |
214
add_sub arg_datetime , INTERVAL CONCAT_WS(':' , arg_hour , arg_minute ) HOUR_MINUTE ) |
215
add_sub arg_datetime , INTERVAL CONCAT_WS(' ' , arg_day , CONCAT_WS(':' , arg_hour , arg_minute, CONCAT_WS('.' , arg_second , arg_microsecond ) DAY_MICROSECOND ) |
216
add_sub arg_datetime , INTERVAL CONCAT_WS(' ' , arg_day , CONCAT_WS(':' , arg_hour , arg_minute , arg_second ) DAY_SECOND ) |
217
add_sub arg_datetime , INTERVAL CONCAT_WS(' ' , arg_day , CONCAT_WS(':' , arg_hour , arg_minute ) DAY_MINUTE ) |
218
add_sub arg_datetime , INTERVAL CONCAT_WS(' ' , arg_day , arg_hours ) DAY_HOUR ) |
219
add_sub arg_datetime , INTERVAL CONCAT_WS('-' , arg_year , arg_month ) YEAR_MONTH ) ;
223
SECOND | MINUTE | HOUR | DAY | WEEK | MONTH | QUARTER | YEAR ;
226
SECOND_MICROSECOND | MINUTE_MICROSECOND | MINUTE_SECOND | HOUR_MICROSECOND | HOUR_SECOND | HOUR_MINUTE | DAY_MICROSECOND | DAY_SECOND | DAY_MINUTE | DAY_HOUR | YEAR_MONTH ;
230
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 ;
234
SECOND | MINUTE | HOUR | DAY | WEEK | MONTH | QUARTER | YEAR ;
237
DATE_ADD( | DATE_SUB( | SUBDATE
240
0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 ;
243
DATE | DATETIME | TIME ;
244
# DATETIME( precision ) | TIME | TIME( precision ) ;
250
GET_FORMAT( date_time_datetime , country_code ) ;
253
DATE | TIME | DATETIME ;
256
EUR | USA | JIS | ISO | INTERNAL ;
260
CONCAT_WS( format_separator , format_list );
263
format_item , format_item |
264
format_item , format_list ;
267
'%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' ;