← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to docs/functions/datetime.rst

  • Committer: Lee Bieber
  • Date: 2011-02-23 05:05:43 UTC
  • mfrom: (2193.1.2 build)
  • Revision ID: kalebral@gmail.com-20110223050543-w0nhgf512s0137mm
Merge Andrew - 723389: ORDER BY on sys_replication_log table causes InnoDB crash
Merge Marisa - documentation updates

Show diffs side-by-side

added added

removed removed

Lines of Context:
docs/functions/datetime.rst
4
4
.. toctree::
5
5
   :hidden: 
6
6
   
7
 
   current_date
8
 
   extract_date
 
7
   current_time_functions
 
8
   extract_date_functions
9
9
   date_trunc
10
10
 
11
11
Current
12
12
-------
13
13
 
14
 
+--------------------------+-------------------------------------+-----------------------------------------------------------------+
15
 
|Name                      |Return Type                          |Description                                                      |
16
 
+==========================+=====================================+=================================================================+
17
 
|current_date              |date                                 |Current date                                                     |
18
 
+--------------------------+-------------------------------------+-----------------------------------------------------------------+
19
 
|current_time              |time with time zone                  |Current time of day                                              |
20
 
+--------------------------+-------------------------------------+-----------------------------------------------------------------+
21
 
|current_timestamp         |timestamp with time zone             |Current date and time (start of current transaction)             |
22
 
+--------------------------+-------------------------------------+-----------------------------------------------------------------+
23
 
|localtime                 |time                                 |Current time of day                                              |
24
 
+--------------------------+-------------------------------------+-----------------------------------------------------------------+
25
 
|localtimestamp            |timestamp                            |Current date and time (start of current transaction)             |
26
 
+--------------------------+-------------------------------------+-----------------------------------------------------------------+
27
 
|now()                     |timestamp with time zone             |Current date and time (start of current transaction)             |
28
 
+--------------------------+-------------------------------------+-----------------------------------------------------------------+
29
 
|statement_timestamp()     |timestamp with time zone             |Current date and time (start of current statement)               |
30
 
+--------------------------+-------------------------------------+-----------------------------------------------------------------+
31
 
|timeofday()               |text                                 |Current date and time (as a text string)                         |
32
 
+--------------------------+-------------------------------------+-----------------------------------------------------------------+
 
14
For examples of the following, see :doc:`current_time_functions`.
 
15
 
 
16
+-----------------------------------+-------------------------------------+-----------------------------------------------------------------+
 
17
|Name                               |Return Type                          |Description                                                      |
 
18
+===================================+=====================================+=================================================================+
 
19
|current_date                       |date                                 |Current date                                                     |
 
20
+-----------------------------------+-------------------------------------+-----------------------------------------------------------------+
 
21
|current_time                       |time with time zone                  |Current time of day                                              |
 
22
+-----------------------------------+-------------------------------------+-----------------------------------------------------------------+
 
23
|current_timestamp                  |timestamp with time zone             |Current date and time (start of current transaction)             |
 
24
+-----------------------------------+-------------------------------------+-----------------------------------------------------------------+
 
25
|localtime                          |time                                 |Current time of day                                              |
 
26
+-----------------------------------+-------------------------------------+-----------------------------------------------------------------+
 
27
|localtimestamp                     |timestamp                            |Current date and time (start of current transaction)             |
 
28
+-----------------------------------+-------------------------------------+-----------------------------------------------------------------+
 
29
|now()                              |timestamp with time zone             |Current date and time (start of current transaction)             |
 
30
+-----------------------------------+-------------------------------------+-----------------------------------------------------------------+
 
31
|statement_timestamp()              |timestamp with time zone             |Current date and time (start of current statement)               |
 
32
+-----------------------------------+-------------------------------------+-----------------------------------------------------------------+
33
33
 
34
34
 
35
35
Extract
36
36
-------
37
37
 
 
38
For examples of the following, see :doc:`extract_date_functions`.
 
39
 
38
40
+--------------------------------+-----------------------+---------------------------------------+
39
41
|Name                            |Return Type            |Description                            |
40
42
+================================+=======================+=======================================+
48
50
+--------------------------------+-----------------------+---------------------------------------+
49
51
 
50
52
 
51
 
date_trunc
52
 
----------
 
53
DATE TRUNC
 
54
-----------
 
55
 
 
56
For an example of the following, see :doc:`date_trunc`.
53
57
 
54
58
+--------------------------------+-----------------------+---------------------------------------+
55
59
|Name                            |Return Type            |Description                            |