|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
February 2nd, 2005, 01:35 PM
|
|||
|
|||
|
DAY, MONTH AND YEAR FUNCTION exists?
Hi again,
I wonder if I can use something like this: SELECT ____________ FROM __________ 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.
|
|
#2
February 2nd, 2005, 03:50 PM
|
|||
|
|||
|
A quick search using google reveals the following:
Code:
SELECT ..... FROM .... WHERE EXTRACT(MONTH FROM dateField) = 1
|
|
#3
February 3rd, 2005, 08:09 AM
|
|||
|
|||
|
Code:
SELECT ..... FROM .... WHERE F_MONTH(DateField) = 1 works perfectly. But ONLY if you install FreeUDFLib. Just google for FreeUDFLib. -- Best regards, Fikret Hasovic http://fikret.fbtalk.net FirebirdSQL Foundation member. - Join today at http://www.firebirdsql.org/ff/foundation JEDI VCS contributor http://jedivcs.sourceforge.net/
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > DAY, MONTH AND YEAR FUNCTION exists? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
