This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dev:sql:functions:extract [2009/12/04 23:40] tdo |
dev:sql:functions:extract [2012/10/26 14:28] (current) |
||
|---|---|---|---|
| Line 54: | Line 54: | ||
| ===== Example ===== | ===== Example ===== | ||
| ==== Example 1 ==== | ==== Example 1 ==== | ||
| + | <code SQL> | ||
| + | select status, | ||
| + | extract(mmm FROM orders.order_date) | ||
| + | from orders | ||
| + | where product_no='PRN4356' | ||
| + | |||
| + | ORDR JANUARY | ||
| + | ORDR DECEMBER | ||
| + | CNCL MARCH | ||
| + | </code> | ||
| + | |||
| {{page>:bottom_add&nofooter&noeditbtn}} | {{page>:bottom_add&nofooter&noeditbtn}} | ||