Difference between revisions of "Talk:Built-in functions and Stored Procedures"
From Apache OpenOffice Wiki
| 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(): | ||
| + | [http://www.hsqldb.org/doc/guide/ch09.html#stored-section] | ||
Revision as of 11:44, 5 November 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(): [1]
