#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2005
    Posts
    14
    Rep Power
    0

    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. #2
  3. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,788
    Rep Power
    349
    A quick search using google reveals the following:
    Code:
    SELECT .....
    FROM ....
    WHERE EXTRACT(MONTH FROM dateField) = 1
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2004
    Location
    Sarajevo, Bosnia
    Posts
    120
    Rep Power
    14
    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/
  6. #4
  7. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2005
    Posts
    14
    Rep Power
    0
    Thanks, it works perfectly.

IMN logo majestic logo threadwatch logo seochat tools logo