← 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:01:36 UTC
  • mfrom: (2414.3.1 fix-bug-850858)
  • Revision ID: me@mark.atwood.name-20110915180136-9vjxgga583y99ivw
merge lp:~vjsamuel/drizzle/fix-bug-850858

Show diffs side-by-side

added added

removed removed

Lines of Context:
docs/functions/extract_date_functions.rst
72
72
 
73
73
*Result: 20*
74
74
 
75
 
microseconds
76
 
^^^^^^^^^^^^
77
 
 
78
 
.. code-block:: mysql
79
 
 
80
 
        SELECT EXTRACT(MICROSECONDS FROM TIME '17:12:28.5');
81
 
 
82
 
The seconds field, including fractional parts, multiplied by 1 000 000; note that this includes full seconds
83
 
 
84
 
*Result: 28500000*
85
 
 
86
75
minute
87
76
^^^^^^
88
77
 
140
129
        
141
130
*Result: 27*
142
131
 
143
 
.. code-block:: mysql
144
 
 
145
 
        SELECT EXTRACT(SECOND FROM TIME '08:15:22.5');
146
 
 
147
 
*Result: 22.5*
148
 
 
149
132
timezone
150
133
^^^^^^^^
151
134