Difference between revisions of "Talk:Built-in functions and Stored Procedures"
From Apache OpenOffice Wiki
m (an example of code in use) |
|||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
For an example: | For an example: | ||
| − | SELECT CURDATE (), MONTH ( | + | SELECT CURDATE (), MONTH ('2010-10-11') FROM "Table" |
| + | |||
| + | (note double, single quotes) | ||
| + | |||
| + | Also: | ||
| + | Here is another list of stored procedures/functions including CAST() and IFNULL(): | ||
| + | [http://www.hsqldb.org/doc/guide/ch09.html#stored-section] | ||
| + | |||
| + | Here is a free download using various built-in functions: [http://extensions.services.openoffice.org/en/project/addressbook] | ||
Latest revision as of 12:52, 4 December 2010
For an example:
SELECT CURDATE (), MONTH ('2010-10-11') FROM "Table"
(note double, single quotes)
Also: Here is another list of stored procedures/functions including CAST() and IFNULL(): [1]
Here is a free download using various built-in functions: [2]
