Difference between revisions of "Talk:Built-in functions and Stored Procedures"

From Apache OpenOffice Wiki
Jump to: navigation, search
 
(One intermediate revision by the same user not shown)
Line 6: Line 6:
  
 
Also:
 
Also:
Here is another list of stored procedures/functions including CAST():
+
Here is another list of stored procedures/functions including CAST() and IFNULL():
 
[http://www.hsqldb.org/doc/guide/ch09.html#stored-section]
 
[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]

Personal tools