← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to docs/functions/extract_date_functions.rst

  • Committer: Mark Atwood
  • Date: 2011-09-15 18:00:15 UTC
  • mfrom: (2414.1.1 fix-bug-850799)
  • Revision ID: me@mark.atwood.name-20110915180015-9hvpwmle0yebbfm9
merge lp:~vjsamuel/drizzle/fix-bug-850799

Show diffs side-by-side

added added

removed removed

Lines of Context:
docs/functions/extract_date_functions.rst
175
175
 
176
176
*Result: 2009*
177
177
 
178
 
date_part
179
 
^^^^^^^^^
180
 
 
181
 
The valid field names for date_part are the same as for extract.
182
 
 
183
 
.. code-block:: mysql
184
 
 
185
 
        SELECT date_part('day', TIMESTAMP '2010-07-16 10:12:05');
186
 
 
187
 
*Result: 16*
188
 
 
189
 
.. code-block:: mysql
190
 
 
191
 
        SELECT date_part('hour', INTERVAL '5 hours 12 minutes');
192
 
 
193
 
*Result: 4*