Show page
Old revisions

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
dev:sql:functions:extract [2010/07/09 03:30]
tdo 		dev:sql:functions:extract [2016/06/28 22:38] (current)
Line 1: Line 1:
 {{page>:​top_add&​nofooter&​noeditbtn}} {{page>:​top_add&​nofooter&​noeditbtn}}
-<​html><​div align="​center"><​span style="​color:​red">​DRAFT</​span></​div></​html>​ 
-====== Omnidex SQL Function: EXTRACT ====== 
 {{page>:​sql_bar&​nofooter&​noeditbtn}} {{page>:​sql_bar&​nofooter&​noeditbtn}}
 +====== Omnidex SQL Function: EXTRACT ======
 ===== Description ===== ===== Description =====
-The EXTRACT function extracts ​an individual ​field value from a specified date_class data type.+The EXTRACT function extracts ​one or more portions of a date, such as a day, month or year.   This is useful for performing logic on portions of a date, such as performing certain actions in certain months. ​ This is also useful for assembling a date string in a specific format. 
 + 
 +This function returns a different datatype based on the requested ​field value.
 ===== Syntax ===== ===== Syntax =====
-  EXTRACT(date_unit FROM date_column) 
  
-== date_unit == +  EXTRACT(date_tokens FROM date_expression)
-Required. The date part that is to be extracted. See below for a complete list of date parts that can be used in this parameter. Click to see a list of valid datefield options.+
  
-The //​date_unit//​ should not be enclosed in either double or single quotes. ​ The values can be entered in either uppercase or lowercase characters.+== date_tokens ==
  
-The return datatype ​of the function varies depending on the type of //date_unit// request ​as shown in the following table.+Required. One or more tokens representing the portions of date to be extracted, as determined by one or more of the strings shown in the table below.  ​//Date_tokens// may also contain punctuation marks to create simple format string for dates, ​as shown in the examples below. ​ When punctuation marks are used, //​date_tokens//​ should be enclosed in single quotes.
  
-Valid //​date_unit//​ options: +{{page>​dev:appendix:​reference:​date_tokens_insert&​noheader&​nofooter&​noeditbtn}}
-^ Date_unit ^ Return Datatype ^ Description ^ +
-| YEAR | INTEGER |Returns Year in CCYY format. | +
-| MONTH | INTEGER |Month | +
-| DAY | INTEGER | Day | +
-| HOUR | |Hour | +
-| MINUTE | | Minute | +
-| SECOND | | Second | +
-| A | | Lowercase am/pm indicator | +
-| AA | | Uppercase AM/PM indicator | +
-| D | | Non-zero-filled day-of-month (1, 2, 3) | +
-| 0D | | Zero-filled day-of-month (01, 02, 03) | +
-| DD | | Day of year (44) | +
-| 0DD | | Zero-filled day of year (044) | +
-| F | | Non-zero-filled fraction of a second (1, 2) |  +
-| 0F | | Zero-filled fraction of a second (01, 02) | +
-| H | | 12-hour, non-zero-filled hour of day (12, 1) | +
-| 0H | | 12-hour, zero-filled hour of day (12, 01) | +
-| HH | | 24-hour, non-zero-filled hour of day (24, 1) |  +
-| 0HH | | 24-hour, zero-filled hour of day (24, 01) | +
-| J | | Non-zero-filled Julian date (1, 2) | +
-| 0J | | Zero-filled Julian date (01, 02) | +
-| M | | Non-zero-filled month number (1-January, 2-February) |  +
-| 0M | | Zero-filled day-of-month number (01-January,​ 02-February) |  +
-| MM | | Three-character month abbreviation (Jan, Feb) | +
-| MMM | |Fully spelled month (January, February) | +
-| N | | Non-zero-filled minute of hour (1, 2) | +
-| 0N | | Zero-filled minute of hour (01, 02) | +
-| Q | | Quarter of the year (1) | +
-| QQ | | Quarter of the year abbreviation (Q1) | +
-| QQQ | | Quarter of the year name (First Quarter) | +
-| S | | Non-zero-filled second of minute (1, 2) |  +
-| 0S | | Zero-filled second of minute (01, 02) | +
-| W | | Day of the week number (1-Sunday, 2-Monday) |  +
-| WW | | Three-character day-of-week abbreviation (Sun, Mon) | +
-| WWW | | Fully spelled day-of-week (Sunday, Monday) |  +
-| YY | | Two-digit year (99, 00) | +
-| YYYY | | Four-digit year (1999, 2000) | +
  
-== FROM == 
-Required. 
  
-== date_column ​== +== date_expression ​== 
-Required. ​A date formatted as any valid SQL92 date_class ​data type.+ 
 +Required. ​Any expression that returns a date-class datatype. Examples of date expressions are columns or functions that return a date-class datatype. ​ The date_class ​datatypes are any of the date or time oriented datatypes found in the list of [[dev:​appendix:​reference:​datatypes|Omnidex datatypes]].  
  
-If the original date is an OMNIDEX DATE or OMNIDEX DATETIME column, the return data type is C STRING length 32.  
 ===== Example ===== ===== Example =====
 +==== Example 1: EXTRACT of MONTH ====
  
 <​code>​ <​code>​
-select ​status, +> select ​birthdate, extract(month from birthdate) mon from individuals;​
-extract(mmm FROM orders.order_date) +
-from orders  +
-where product_no='​PRN4356'​+
  
-ORDR   ​JANUARY +BIRTHDATE ​    MON 
-ORDR   ​DECEMBER +------------ ​ ----------- 
-CNCL   MARCH+  ​1938-07-14 ​           7 
 +  1957-11-22 ​          11 
 +  1960-07-28 ​           7 
 +  1929-08-22 ​           8 
 +  1933-07-09 ​           7 
 +  1944-08-01 ​           8 
 +  2004-09-14 ​           9
 </​code>​ </​code>​
-===== EXTRACT ​DESCRIBES - Remove ======+==== Example 2: EXTRACT ​with format string ​==== 
 <​code>​ <​code>​
 +> select birthdate, extract ('MMM D, YYYY' from birthdate) bday from individuals;​
  
-> use extract_describe.sql +BIRTHDATE ​    BDAY 
--> select extract(YEAR ​  from current_date) from $omnidex;+------------ ​ ------------------- 
 +  1938-07-14 ​ July 14, 1938 
 +  1957-11-22 ​ November 22, 1957 
 +  1960-07-28 ​ July 28, 1960 
 +  1929-08-22 ​ August 22, 1929 
 +  1933-07-09 ​ July 9, 1933 
 +  1944-08-01 ​ August 1, 1944 
 +  2004-09-14 ​ September 14, 2004 
 +</code>
  
-EXTRACT(YEA +====== Additional Resources ======
------------ +
-       ​2010 +
-1 row returned +
-->  describe +
- ​------------------------------------------------------------------------------ +
- Expr. (1)   : EXTRACT(YEAR FROM CURRENT_DATE) +
- ​Occurrences : 1                                             ​Length:​ 016C01D0 +
- ​Actual ​    0: INT +
- ​Request ​   0: C STRING(11) ​                           VALUE EXP OVRFL +
- ​------------------------------------------------------------------------------ +
--> select extract(MONTH from current_date) from $omnidex;+
  
-EXTRACT(MON +See also: 
------------ +{{page>dev:sql:functions:see_also_dates&​noheader&​nofooter&​noeditbtn}}
-          7 +
-1 row returned +
-->  ​describe +
- ​------------------------------------------------------------------------------ +
- Expr. (1)   : EXTRACT(MONTH FROM CURRENT_DATE) +
- ​Occurrences ​: 1                                             ​Length: 016C01D0 +
- ​Actual ​    0: INT +
- ​Request ​   0: C STRING(11) ​                           VALUE EXP OVRFL +
- ​------------------------------------------------------------------------------ +
--> select extract(DAY ​   from current_date) from $omnidex;+
  
-EXTRACT(DAY 
------------ 
-          8 
-1 row returned 
-->  describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT(DAY FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: INT 
- ​Request ​   0: C STRING(11) ​                           VALUE EXP OVRFL 
- ​------------------------------------------------------------------------------ 
--> select extract(HOUR ​         from current_date) from $omnidex; 
  
-EXTRACT(HOU 
------------ 
-          0 
-1 row returned 
-->  describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT(HOUR FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: INT 
- ​Request ​   0: C STRING(11) ​                           VALUE EXP OVRFL 
- ​------------------------------------------------------------------------------ 
--> select extract(MINUTE from current_date) from $omnidex; 
- 
-EXTRACT(MIN 
------------ 
-          0 
-1 row returned 
-->  describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT(MINUTE FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: INT 
- ​Request ​   0: C STRING(11) ​                           VALUE EXP OVRFL 
- ​------------------------------------------------------------------------------ 
--> select extract(SECOND from current_date) from $omnidex; 
- 
-EXTRACT(SEC 
------------ 
-          0 
-1 row returned 
-->  describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT(SECOND FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: INT 
- ​Request ​   0: C STRING(11) ​                           VALUE EXP OVRFL 
- ​------------------------------------------------------------------------------ 
--> select extract(A ​            from current_date) from $omnidex; 
- 
-EX 
--- 
-am 
-1 row returned 
-->  describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT('​A'​ FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: C STRING(2) 
- ​Request ​   0: C STRING(2) ​                            TRUN VALUE EXP 
- ​------------------------------------------------------------------------------ 
--> select extract(AA ​           from current_date) from $omnidex; 
- 
-EX 
--- 
-AM 
-1 row returned 
-->  describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT('​AA'​ FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: C STRING(2) 
- ​Request ​   0: C STRING(2) ​                            TRUN VALUE EXP 
- ​------------------------------------------------------------------------------ 
--> select extract(D ​            from current_date) from $omnidex; 
- 
-EXTRACT('​D'​ 
------------ 
-          8 
-1 row returned 
-->  describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT('​D'​ FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: INT 
- ​Request ​   0: C STRING(11) ​                           VALUE EXP OVRFL 
- ​------------------------------------------------------------------------------ 
--> select extract(0D ​           from current_date) from $omnidex; 
- 
-EX 
--- 
-08 
-1 row returned 
-->  describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT('​0D'​ FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: C STRING(2) 
- ​Request ​   0: C STRING(2) ​                            TRUN VALUE EXP 
- ​------------------------------------------------------------------------------ 
--> select extract(DD ​           from current_date) from $omnidex; 
- 
-EXTRACT('​DD 
------------ 
-        189 
-1 row returned 
-->  describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT('​DD'​ FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: INT 
- ​Request ​   0: C STRING(11) ​                           VALUE EXP OVRFL 
- ​------------------------------------------------------------------------------ 
--> select extract(0DD ​          from current_date) from $omnidex; 
- 
-EXT 
---- 
-189 
-1 row returned 
-->  describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT('​0DD'​ FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: C STRING(3) 
- ​Request ​   0: C STRING(3) ​                            TRUN VALUE EXP 
- ​------------------------------------------------------------------------------ 
--> select extract(F ​            from current_date) from $omnidex; 
- 
-EXTRACT('​F'​ 
------------ 
-          0 
-1 row returned 
-->  describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT('​F'​ FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: INT 
- ​Request ​   0: C STRING(11) ​                           VALUE EXP OVRFL 
- ​------------------------------------------------------------------------------ 
--> disconnect; 
-Disconnected 
--> select extract(0F ​           from current_date) from $omnidex; 
-*E* This statement requires a connection to an environment file 
-> 
--> select extract(0F ​           from current_date) from $omnidex; 
- 
-EX 
--- 
-00 
-1 row returned 
-->  describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT('​0F'​ FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: C STRING(2) 
- ​Request ​   0: C STRING(2) ​                            TRUN VALUE EXP 
- ​------------------------------------------------------------------------------ 
--> select extract(H ​            from current_date) from $omnidex; 
- 
-EXTRACT('​H'​ 
------------ 
-          0 
-1 row returned 
-->  describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT('​H'​ FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: INT 
- ​Request ​   0: C STRING(11) ​                           VALUE EXP OVRFL 
- ​------------------------------------------------------------------------------ 
--> select extract(0H ​           from current_date) from $omnidex; 
- 
-EX 
--- 
-00 
-1 row returned 
-->  describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT('​0H'​ FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: C STRING(2) 
- ​Request ​   0: C STRING(2) ​                            TRUN VALUE EXP 
- ​------------------------------------------------------------------------------ 
--> select extract(HH ​           from current_date) from $omnidex; 
- 
-EXTRACT('​HH 
------------ 
-          0 
-1 row returned 
-->  describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT('​HH'​ FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: INT 
- ​Request ​   0: C STRING(11) ​                           VALUE EXP OVRFL 
- ​------------------------------------------------------------------------------ 
--> select extract(0HH ​          from current_date) from $omnidex; 
- 
-EX 
--- 
-00 
-1 row returned 
-->  describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT('​0HH'​ FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: C STRING(2) 
- ​Request ​   0: C STRING(2) ​                            TRUN VALUE EXP 
- ​------------------------------------------------------------------------------ 
--> select extract(J ​            from current_date) from $omnidex; 
- 
-EXTRACT('​J'​ FROM CURRENT_DATE) 
--------------------------------- 
-                  2455385.500000 
-1 row returned 
-->  describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT('​J'​ FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: DOUBLE 
- ​Request ​   0: C STRING(32) ​                           VALUE EXP OVRFL 
- ​------------------------------------------------------------------------------ 
--> select extract(0J ​           from current_date) from $omnidex; 
- 
-EXTRACT('​0J 
------------ 
-2455385.500 
-1 row returned 
-->  describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT('​0J'​ FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: C STRING(11) 
- ​Request ​   0: C STRING(11) ​                           TRUN VALUE EXP 
- ​------------------------------------------------------------------------------ 
--> select extract(M ​            from current_date) from $omnidex; 
- 
-EXTRACT('​M'​ 
------------ 
-          7 
-1 row returned 
-->  describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT('​M'​ FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: INT 
- ​Request ​   0: C STRING(11) ​                           VALUE EXP OVRFL 
- ​------------------------------------------------------------------------------ 
--> select extract(0M ​           from current_date) from $omnidex; 
- 
-EX 
--- 
-07 
-1 row returned 
-->  describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT('​0M'​ FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: C STRING(2) 
- ​Request ​   0: C STRING(2) ​                            TRUN VALUE EXP 
- ​------------------------------------------------------------------------------ 
--> select extract(MM ​           from current_date) from $omnidex; 
- 
-EXT 
---- 
-Jul 
-1 row returned 
-->  describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT('​MM'​ FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: C STRING(3) 
- ​Request ​   0: C STRING(3) ​                            TRUN VALUE EXP 
- ​------------------------------------------------------------------------------ 
--> select extract(MMM ​          from current_date) from $omnidex; 
- 
-EXTR 
----- 
-July 
-1 row returned 
-->  describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT('​MMM'​ FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: C STRING(4) 
- ​Request ​   0: C STRING(4) ​                            TRUN VALUE EXP 
- ​------------------------------------------------------------------------------ 
--> select extract(N ​            from current_date) from $omnidex; 
- 
-EXTRACT('​N'​ 
------------ 
-          0 
-1 row returned 
-->  describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT('​N'​ FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: INT 
- ​Request ​   0: C STRING(11) ​                           VALUE EXP OVRFL 
- ​------------------------------------------------------------------------------ 
--> select extract(0N ​           from current_date) from $omnidex; 
- 
-EX 
--- 
-00 
-1 row returned 
-->  describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT('​0N'​ FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: C STRING(2) 
- ​Request ​   0: C STRING(2) ​                            TRUN VALUE EXP 
- ​------------------------------------------------------------------------------ 
--> select extract(Q ​            from current_date) from $omnidex; 
- 
-EXTRACT('​Q'​ 
------------ 
-          3 
-1 row returned 
-->  describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT('​Q'​ FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: INT 
- ​Request ​   0: C STRING(11) ​                           VALUE EXP OVRFL 
- ​------------------------------------------------------------------------------ 
--> select extract(QQ ​           from current_date) from $omnidex; 
- 
-EX 
--- 
-Q3 
-1 row returned 
-->  describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT('​QQ'​ FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: C STRING(2) 
- ​Request ​   0: C STRING(2) ​                            TRUN VALUE EXP 
- ​------------------------------------------------------------------------------ 
--> select extract(QQQ ​          from current_date) from $omnidex; 
- 
-EXTRACT('​QQQ'​ 
-------------- 
-Third Quarter 
-1 row returned 
-->  describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT('​QQQ'​ FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: C STRING(13) 
- ​Request ​   0: C STRING(13) ​                           TRUN VALUE EXP 
- ​------------------------------------------------------------------------------ 
--> select extract(S ​            from current_date) from $omnidex; 
- 
-EXTRACT('​S'​ 
------------ 
-          0 
-1 row returned 
-->  describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT('​S'​ FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: INT 
- ​Request ​   0: C STRING(11) ​                           VALUE EXP OVRFL 
- ​------------------------------------------------------------------------------ 
--> select extract(0S ​           from current_date) from $omnidex; 
- 
-EX 
--- 
-00 
-1 row returned 
-->  describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT('​0S'​ FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: C STRING(2) 
- ​Request ​   0: C STRING(2) ​                            TRUN VALUE EXP 
- ​------------------------------------------------------------------------------ 
--> select extract(W ​            from current_date) from $omnidex; 
- 
-EXTRACT('​W'​ 
------------ 
-          5 
-1 row returned 
-->  describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT('​W'​ FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: INT 
- ​Request ​   0: C STRING(11) ​                           VALUE EXP OVRFL 
- ​------------------------------------------------------------------------------ 
--> select extract(WW ​           from current_date) from $omnidex; 
- 
-EXT 
---- 
-Thu 
-1 row returned 
-->  describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT('​WW'​ FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: C STRING(3) 
- ​Request ​   0: C STRING(3) ​                            TRUN VALUE EXP 
- ​------------------------------------------------------------------------------ 
--> select extract(WWW ​          from current_date) from $omnidex; 
- 
-EXTRACT( 
--------- 
-Thursday 
-1 row returned 
-->  describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT('​WWW'​ FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: C STRING(8) 
- ​Request ​   0: C STRING(8) ​                            TRUN VALUE EXP 
- ​------------------------------------------------------------------------------ 
--> select extract(YY ​           from current_date) from $omnidex; 
- 
-EX 
--- 
-10 
-1 row returned 
-->  describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT('​YY'​ FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: C STRING(2) 
- ​Request ​   0: C STRING(2) ​                            TRUN VALUE EXP 
- ​------------------------------------------------------------------------------ 
--> select extract(YYYY ​    from current_date) from $omnidex; 
- 
-EXTRACT('​YY 
------------ 
-       2010 
-1 row returned 
--> describe 
- ​------------------------------------------------------------------------------ 
- Expr. (1)   : EXTRACT('​YYYY'​ FROM CURRENT_DATE) 
- ​Occurrences : 1                                             ​Length:​ 016C01D0 
- ​Actual ​    0: INT 
- ​Request ​   0: C STRING(11) ​                           VALUE EXP OVRFL 
- ​------------------------------------------------------------------------------ 
-> 
-</​code>​ 
 {{page>:​bottom_add&​nofooter&​noeditbtn}} {{page>:​bottom_add&​nofooter&​noeditbtn}}
 
Back to top
dev/sql/functions/extract.1278646209.txt.gz · Last modified: 2016/06/28 22:38 (external edit)
Sitemap Recent Changes