в 13:44, 26 мая 2010

2010-05-26T13:44:56Z

Admin: 1 версия

2010-05-26T09:50:38Z

1 версия

Новая страница

== EXTRACT(unit FROM date): extracts parts from the date rather than performing date arithmetic==

<p>The following table shows the expected form of the expr argument for each unit value.</p>
unit Value
Expected expr Format
MICROSECOND
MICROSECONDS
SECOND
SECONDS
MINUTE
MINUTES
HOUR
HOURS
DAY
DAYS
WEEK
WEEKS
MONTH
MONTHS
QUARTER
QUARTERS
YEAR
YEARS
SECOND_MICROSECOND
"SECONDS.MICROSECONDS"
MINUTE_MICROSECOND
"MINUTES.MICROSECONDS"
MINUTE_SECOND
"MINUTES:SECONDS"
HOUR_MICROSECOND
"HOURS.MICROSECONDS"
HOUR_SECOND
"HOURS:MINUTES:SECONDS"
HOUR_MINUTE
"HOURS:MINUTES"
DAY_MICROSECOND
"DAYS.MICROSECONDS"
DAY_SECOND
"DAYS HOURS:MINUTES:SECONDS"
DAY_MINUTE
"DAYS HOURS:MINUTES"
DAY_HOUR
"DAYS HOURS"
YEAR_MONTH
"YEARS-MONTHS"

== SELECT EXTRACT(DAY FROM "2003-30:00.000123");==



<source lang="sql">
mysql>
mysql>
mysql> SELECT EXTRACT(DAY FROM "2003-01-02 10:30:00.000123");
+------------------------------------------------+
| EXTRACT(DAY FROM "2003-01-02 10:30:00.000123") |
+------------------------------------------------+
| 2 |
+------------------------------------------------+
1 row in set (0.00 sec)</source>

== SELECT EXTRACT(DAY_HOUR FROM "2003-30:00.000123");==



<source lang="sql">
mysql>
mysql> SELECT EXTRACT(DAY_HOUR FROM "2003-01-02 10:30:00.000123");
+-----------------------------------------------------+
| EXTRACT(DAY_HOUR FROM "2003-01-02 10:30:00.000123") |
+-----------------------------------------------------+
| 210 |
+-----------------------------------------------------+
1 row in set (0.00 sec)
mysql></source>

== SELECT EXTRACT(DAY_MICROSECOND FROM "2003-30:00.000123");==



<source lang="sql">
mysql>
mysql>
mysql> SELECT EXTRACT(DAY_MICROSECOND FROM "2003-01-02 10:30:00.000123");
+------------------------------------------------------------+
| EXTRACT(DAY_MICROSECOND FROM "2003-01-02 10:30:00.000123") |
+------------------------------------------------------------+
| 2103000000123 |
+------------------------------------------------------------+
1 row in set (0.00 sec)
mysql>
mysql></source>

== SELECT EXTRACT(DAY_MINUTE FROM "1999-02:03");==



<source lang="sql">
mysql>
mysql> SELECT EXTRACT(DAY_MINUTE FROM "1999-07-02 01:02:03");
+------------------------------------------------+
| EXTRACT(DAY_MINUTE FROM "1999-07-02 01:02:03") |
+------------------------------------------------+
| 20102 |
+------------------------------------------------+
1 row in set (0.00 sec)
mysql></source>

== SELECT EXTRACT(DAY_SECOND FROM "2003-30:00.000123");==



<source lang="sql">
mysql>
mysql>
mysql> SELECT EXTRACT(DAY_SECOND FROM "2003-01-02 10:30:00.000123");
+-------------------------------------------------------+
| EXTRACT(DAY_SECOND FROM "2003-01-02 10:30:00.000123") |
+-------------------------------------------------------+
| 2103000 |
+-------------------------------------------------------+
1 row in set (0.00 sec)</source>

== SELECT EXTRACT(HOUR FROM "2003-30:00.000123");==



<source lang="sql">
mysql>
mysql>
mysql> SELECT EXTRACT(HOUR FROM "2003-01-02 10:30:00.000123");
+-------------------------------------------------+
| EXTRACT(HOUR FROM "2003-01-02 10:30:00.000123") |
+-------------------------------------------------+
| 10 |
+-------------------------------------------------+
1 row in set (0.00 sec)</source>

== SELECT EXTRACT(HOUR_MICROSECOND FROM "2003-30:00.000123");==



<source lang="sql">
mysql>
mysql>
mysql> SELECT EXTRACT(HOUR_MICROSECOND FROM "2003-01-02 10:30:00.000123");
+-------------------------------------------------------------+
| EXTRACT(HOUR_MICROSECOND FROM "2003-01-02 10:30:00.000123") |
+-------------------------------------------------------------+
| 103000000123 |
+-------------------------------------------------------------+
1 row in set (0.00 sec)</source>

== SELECT EXTRACT(HOUR_MINUTE FROM "2003-30:00.000123");==



<source lang="sql">
mysql>
mysql>
mysql> SELECT EXTRACT(HOUR_MINUTE FROM "2003-01-02 10:30:00.000123");
+--------------------------------------------------------+
| EXTRACT(HOUR_MINUTE FROM "2003-01-02 10:30:00.000123") |
+--------------------------------------------------------+
| 1030 |
+--------------------------------------------------------+
1 row in set (0.00 sec)</source>

== SELECT EXTRACT(HOUR_SECOND FROM "2003-30:00.000123");==



<source lang="sql">
mysql>
mysql>
mysql> SELECT EXTRACT(HOUR_SECOND FROM "2003-01-02 10:30:00.000123");
+--------------------------------------------------------+
| EXTRACT(HOUR_SECOND FROM "2003-01-02 10:30:00.000123") |
+--------------------------------------------------------+
| 103000 |
+--------------------------------------------------------+
1 row in set (0.00 sec)</source>

== SELECT EXTRACT(MICROSECOND FROM "2003-30:00.000123");==



<source lang="sql">
mysql>
mysql> SELECT EXTRACT(MICROSECOND FROM "2003-01-02 10:30:00.000123");
+--------------------------------------------------------+
| EXTRACT(MICROSECOND FROM "2003-01-02 10:30:00.000123") |
+--------------------------------------------------------+
| 123 |
+--------------------------------------------------------+
1 row in set (0.00 sec)
mysql></source>

== SELECT EXTRACT(MINUTE FROM "2003-30:00.000123");==



<source lang="sql">
mysql>
mysql>
mysql> SELECT EXTRACT(MINUTE FROM "2003-01-02 10:30:00.000123");
+---------------------------------------------------+
| EXTRACT(MINUTE FROM "2003-01-02 10:30:00.000123") |
+---------------------------------------------------+
| 30 |
+---------------------------------------------------+
1 row in set (0.00 sec)</source>

== SELECT EXTRACT(MINUTE_MICROSECOND FROM "2003-30:00.000123");==



<source lang="sql">
mysql>
mysql>
mysql> SELECT EXTRACT(MINUTE_MICROSECOND FROM "2003-01-02 10:30:00.000123");
+---------------------------------------------------------------+
| EXTRACT(MINUTE_MICROSECOND FROM "2003-01-02 10:30:00.000123") |
+---------------------------------------------------------------+
| 3000000123 |
+---------------------------------------------------------------+
1 row in set (0.00 sec)</source>

== SELECT EXTRACT(MINUTE_SECOND FROM "2003-30:00.000123");==



<source lang="sql">
mysql>
mysql>
mysql> SELECT EXTRACT(MINUTE_SECOND FROM "2003-01-02 10:30:00.000123");
+----------------------------------------------------------+
| EXTRACT(MINUTE_SECOND FROM "2003-01-02 10:30:00.000123") |
+----------------------------------------------------------+
| 3000 |
+----------------------------------------------------------+
1 row in set (0.00 sec)
mysql>
mysql></source>

== SELECT EXTRACT(MONTH FROM "2003-30:00.000123");==



<source lang="sql">
mysql>
mysql>
mysql> SELECT EXTRACT(MONTH FROM "2003-01-02 10:30:00.000123");
+--------------------------------------------------+
| EXTRACT(MONTH FROM "2003-01-02 10:30:00.000123") |
+--------------------------------------------------+
| 1 |
+--------------------------------------------------+
1 row in set (0.00 sec)</source>

== SELECT EXTRACT(QUARTER FROM "2003-30:00.000123");==



<source lang="sql">
mysql>
mysql>
mysql> SELECT EXTRACT(QUARTER FROM "2003-01-02 10:30:00.000123");
+----------------------------------------------------+
| EXTRACT(QUARTER FROM "2003-01-02 10:30:00.000123") |
+----------------------------------------------------+
| 1 |
+----------------------------------------------------+
1 row in set (0.00 sec)</source>

== SELECT EXTRACT(SECOND FROM "2003-30:00.000123");==



<source lang="sql">
mysql>
mysql>
mysql>
mysql> SELECT EXTRACT(SECOND FROM "2003-01-02 10:30:00.000123");
+---------------------------------------------------+
| EXTRACT(SECOND FROM "2003-01-02 10:30:00.000123") |
+---------------------------------------------------+
| 0 |
+---------------------------------------------------+
1 row in set (0.00 sec)</source>

== SELECT EXTRACT(SECOND_MICROSECOND FROM "2003-30:00.000123");==



<source lang="sql">
mysql>
mysql>
mysql> SELECT EXTRACT(SECOND_MICROSECOND FROM "2003-01-02 10:30:00.000123");
+---------------------------------------------------------------+
| EXTRACT(SECOND_MICROSECOND FROM "2003-01-02 10:30:00.000123") |
+---------------------------------------------------------------+
| 123 |
+---------------------------------------------------------------+
1 row in set (0.00 sec)</source>

== SELECT EXTRACT(WEEK FROM "2003-30:00.000123");==



<source lang="sql">
mysql>
mysql>
mysql> SELECT EXTRACT(WEEK FROM "2003-01-02 10:30:00.000123");
+-------------------------------------------------+
| EXTRACT(WEEK FROM "2003-01-02 10:30:00.000123") |
+-------------------------------------------------+
| 0 |
+-------------------------------------------------+
1 row in set (0.00 sec)</source>

== SELECT EXTRACT(YEAR FROM "1999-07-02");==



<source lang="sql">
mysql>
mysql> SELECT EXTRACT(YEAR FROM "1999-07-02");
+---------------------------------+
| EXTRACT(YEAR FROM "1999-07-02") |
+---------------------------------+
| 1999 |
+---------------------------------+
1 row in set (0.00 sec)
mysql></source>

== SELECT EXTRACT(YEAR_MONTH FROM "1999-02:03");==



<source lang="sql">
mysql>
mysql> SELECT EXTRACT(YEAR_MONTH FROM "1999-07-02 01:02:03");
+------------------------------------------------+
| EXTRACT(YEAR_MONTH FROM "1999-07-02 01:02:03") |
+------------------------------------------------+
| 199907 |
+------------------------------------------------+
1 row in set (0.00 sec)
mysql></source>

← Предыдущая	Версия 13:44, 26 мая 2010
(нет различий)

MySQL Tutorial/Date Time Functions/EXTRACT - История изменений

в 13:44, 26 мая 2010

Admin: 1 версия