~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to docs/scalarfunctions.rst

• browse files at revision 2063
• compare with another revision
• download diff
• download tarball
• view history from revision 2063

Show diffs side-by-side

added

removed

docs/scalarfunctions.rst

 

1

Scalar functions

 

2

================

 

3

 

 

4

*SQL scalar functions are based on the input value, and return a single value.*

 

5

 

 

6

General syntax for scalar functions is: ::

 

7

 

 

8

        SELECT "function type" ("column_name")

 

9

        FROM "table_name"

 

10

 

 

11

Click on the following scalar functions to learn more:

 

12

 

 

13

    * UCASE() - Converts a field to upper case

 

14

    * LCASE() - Converts a field to lower case

 

15

    * MID() - Extract characters from a text field

 

16

    * LEN() - Returns the length of a text field

 

17

    * ROUND() - Rounds a numeric field to the number of decimals specified

 

18

    * NOW() - Returns the current system date and time

 

19

    * FORMAT() - Formats how a field is to be displayed

 

20

 

 

21

 

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1