Thanks Dimitry Sibiryakov for your good will.
Thanks Alexandre Benson Smith for the rfunc tip.
Thanks Carlos H. Cantu for your good will.
Thanks Julio Cesar for your good will.
Thanks Ann W. Harrison for your good will.
Thanks Milan Babuskov for the Firebird FAQ, FreeadhocUDF and rfunc tips.
Special thanks to the Firebird Team that is making Firebird each new version easier to make viable this hard programming stuff.


I have solved my problems through FreeadhocUDF's F_GFORMATD function:
SELECT '01-10-2005 15:09:12' AS ISCORRECT, F_GFORMATD('dd/mm/yyyy', '01.10.2005 15:09:12') as correct FROM RDB$DATABASE;

Just remembering that my problem was that I use third party tools to send email and SMS (mobile phone messages) to customers and suppliers.
I do not have access to the source code of these tools. I just prepare the required XML file to these tools to work.
Inside firebird triggers and stored procedures, I populate an external Firebird table that is easily and fastly transformed in this XML file by my own program.
Summing up, the heavy process is all done inside Firebird which has all necessary data.

I hope, in the future, Firebird can handle XML, send email (receiving email is not important in my case) and send SMS because implement and integrate all these features using closed third party tools takes a lot of time and hard work and never works as we expect.

Best wishes,

Roberto Carlos

--- In firebird-support@yahoogroups.com, Milan Babuskov <milanb@...> wrote:
>
> Roberto Carlos wrote:
> > How can I simulate Delphi's FormatDateTime('dd/mm/yyyy', Now) in triggers and stored procedures?
>
> http://www.firebirdfaq.org/faq314
>
> Regards,
>
> --
> Milan Babuskov
>
> ==================================
> The easiest way to import XML, CSV
> and textual files into Firebird:
> http://www.guacosoft.com/xmlwizard
> ==================================
>