February 2nd, 2005, 02:35 PM
DAY, MONTH AND YEAR FUNCTION exists?
I wonder if I can use something like this:
WHERE MONTH(DateField) = 1 /* January */
Could you point me to some link where I can learn how to deal with Firebird's stored procedures, functions, etc.?
I want to swith to Firebird, but it's getting harder than I thought.
Thanks in advance.
February 2nd, 2005, 04:50 PM
A quick search using google reveals the following:
WHERE EXTRACT(MONTH FROM dateField) = 1
February 3rd, 2005, 09:09 AM
February 3rd, 2005, 01:09 PM
Thanks, it works perfectly.