DATE_FORMAT in Firebird?

Is there another name for the DATE_FORMAT function in Firebird, or is it a UDF? thanks

What exactly are you asking ? Whether Firebird has some built-in function for formatting dates ? No, formatting is normally done on client.

However, you can either CAST date to varchar (in which case you do not have the chioce of formatting details, the result will always be yyyy-mm-dd), or you can use built-in function EXTRACT to decompose date to its parts (day, month, year) and then put them together the way you like.

Ivan

Thank You! EXTRACT might be what i look for then =) in MySQL there is a function called FORMAT_DATE where you can decompose date into pats =) and just choose which parts and how you want to return em =) but EXTRACT will do just fine i guess, thanks

i need to know how to obtain de system date value
¿wich is the command?
-ex. in SQLServer is getdate()-



and, the command to transform a number to date?
-ex. 2005-int to 2005like year-



can anybody help me?

Try current_date, current_time...

--
Best regards,
Fikret Hasovic http://fikret.fbtalk.net
USAID TAMP Senior Programmer

* Firebird Foundation member.
- Join today at http://www.firebirdsql.org/ff/foundation
* JEDI VCS contributor
http://jedivcs.sourceforge.net/
* Firebird and Fyracle news
http://www.fyracle.org

or you can use NOW.