--- In firebird-support@yahoogroups.com, "Olaf Kluge" <olaf.kluge@...> wrote:

>
> Hello,
>
> many thanks.
>
> Freeadhocudf works now. I have installed the ■Microsoft Visual C++ 2008 SP1 Redistributable Package (x64). According to the description is only required for windows xp.
>
> regarding the formatting of the date I think I can realize this with substring.
>
> Best thanks
>
> Olaf
> ___________________
>
> > eventually are this functions a part of firebird?
>
> Check out the new built-in functions in Firebird 2.1 release notes p.155ff:
>
> > Pow? (multiply) 10³ etc.
>
> POWER
>
> > Format Date: Input a timestamp, format (f. e. 'dd-mm-yy hh'), output
> > String
> > '23-05-11 15'
>
> Don't think so.
>
>
> > P_left - input string + character to fill + number of chars filled: (f. e.
> > '18', '0', 10) = '0000000018'
>
> LPAD
>
> > P_right - the same how p_left, but in other direction: 'House' = 'House____'
>
> RPAD
>
> > RTRIM - trims empty chars from a string
>
> TRIM with various options.
>
>
> --
> With regards,
>
> Thomas Steinmaurer
> Upscene Productions
> http://www.upscene.com
> http://blog.upscene.com/thomas/
>
> Download LogManager Series, FB TraceManager today!
> Continuous Database Monitoring Solutions supporting Firebird, InterBase, Advantage Database, MS SQL Server and NexusDB!
>
>
>
> > Thank you.
> >
> >
> >> Thanks Thomas, but the gds32.dll is present in system32. Could it be
> >> that server 2008 blocks this dlls? I need some functions from fah.libary.
> >
> > I don't know. You'd better get in touch with the FreeAdhocUDF guys.
> >
> >
> > --
> > With regards,
> >
> > Thomas Steinmaurer
> > Upscene Productions
> > http://www.upscene.com
> > http://blog.upscene.com/thomas/
> >
> > Download LogManager Series, FB TraceManager today!
> > Continuous Database Monitoring Solutions supporting Firebird,
> > InterBase, Advantage Database, MS SQL Server and NexusDB!
> >
> >
> >
> >
> >> Thank you.
> >>
> >>> on my local machine I have Windows XP installed and Firebird 2.5 cs
> >>> is running. The freeadhocudf für 32 Bit is located in the
> >>> udf-folder, all ICU-FAU*-dlls are in the bin-folder. All works fine.
> >>>
> >>>
> >>>
> >>> Now I installed a new machine with 64 Bit Windows Server 2008. Port
> >>> 3050 is open to connect to firebird. I have installed firebird 2.5
> >>> cs
> >>> 64 Bit and I copied the 64 Bit Versions from freeadhocudf.dll and
> >>> ICU-FAU-DLLS into the folders. I can connect to firebird, but the
> >>> UDFs does not work! “Module name or entrypoint not found”. What can
> >>> be the problem? New compiling of the udf does not help, deleting and
> >>> new creating
> >> also not.
> >>
> >> I don't use FreeAdhocUDF, but another dependency might be gds32.dll
> >> in the Windows system directory?
> >>
> >> Just a wild guess ...
> >>
> >>
> >> --
> >> With regards,
> >>
> >> Thomas Steinmaurer
> >> Upscene Productions
> >> http://www.upscene.com
> >> http://blog.upscene.com/thomas/
> >>
> >> Download LogManager Series, FB TraceManager today!
> >> Continuous Database Monitoring Solutions supporting Firebird,
> >> InterBase, Advantage Database, MS SQL Server and NexusDB!
> >>
> >>
> >> ------------------------------------
> >>
> >> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >>
> >> Visit http://www.firebirdsql.org and click the Resources item on the
> >> main
> >> (top) menu. Try Knowledgebase and FAQ links !
> >>
> >> Also search the knowledgebases at http://www.ibphoenix.com
> >>
> >> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >> Yahoo! Groups Links
> >>
> >>
> >>
> >>
> >>
> >> ------------------------------------
> >>
> >> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >>
> >> Visit http://www.firebirdsql.org and click the Resources item on the
> >> main (top) menu. Try Knowledgebase and FAQ links !
> >>
> >> Also search the knowledgebases at http://www.ibphoenix.com
> >>
> >> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >> Yahoo! Groups Links
> >>
> >>
> >>
> >
> >
> >
> > ------------------------------------
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Visit http://www.firebirdsql.org and click the Resources item on the
> > main
> > (top) menu. Try Knowledgebase and FAQ links !
> >
> > Also search the knowledgebases at http://www.ibphoenix.com
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> > ------------------------------------
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Visit http://www.firebirdsql.org and click the Resources item on the
> > main (top) menu. Try Knowledgebase and FAQ links !
> >
> > Also search the knowledgebases at http://www.ibphoenix.com
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > Yahoo! Groups Links
> >
> >
> >
>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>

for date formating 'dd-mm-yy hh'
if field name is: dt

LPAD(EXTRACT(day from dt), 2, 0) || '-' ||
LPAD(EXTRACT(month from dt), 2, '0') || '-' ||
RIGHT(EXTRACT(YEAR FROM dt), 2) || ' ' ||
LPAD(EXTRACT(hour from dt), 2, '0')


Karol Bieniaszewski