Hi!
Since Firebird 2.5, we have been able to replace almost all UDFs with built-in
functions.
There is only one left (it’s the Highlander :)) : formatting dates and
timestamps to readable format for hungarian people:
-- Hungarian format
select to_char(cast('TODAY' as date), 'YYYY.MM.DD') from rdb$database
-- 2021.05.19
-- English format
select to_char(cast('TODAY' as date), 'DD/MM/YYYY') from rdb$database
-- 19/05/2021
-- Year + month
select to_char(cast('TODAY' as date), 'YY/MM') from rdb$database
-- 21/05
-- Short hungarian format
select to_char(cast('2001.5.7' as date), 'YY.MM.DD') from rdb$database
-- 01.05.07
-- Hungarian timestamp format
select to_char(cast('NOW' as timestamp), 'YYYY.MM.DD hh:mm:ss') from
rdb$database
-- 2021.05.19 19:05:46
etc.
If anyone has an idea of what can be used instead, I would greatly appreciate
it.
Of course, a built-in function would be best, but please, this should not be
the suggestion:
select extract(year from cast('NOW' as timestamp)) || '.' ||
lpad(extract(month from cast('NOW' as timestamp)), 2, '0') || '.' ||
lpad(extract(day from cast('NOW' as timestamp)), 2, '0') || ' ' ||
lpad(extract(hour from cast('NOW' as timestamp)), 2, '0') || ':' ||
lpad(extract(minute from cast('NOW' as timestamp)), 2, '0') || ':' ||
lpad(extract(second from cast('NOW' as timestamp)), 2, '0')
from rdb$database
:)
András
From: Nils Bödeker [mailto:[email protected]]
Sent: Wednesday, May 19, 2021 6:34 PM
To: For discussion among Firebird Developers
<[email protected]>
Subject: Re: [Firebird-devel] Deprecations
Hello
as user opinion (sorry)
We still using UDFs.
Own written and external like this one
http://freeadhocudf.org<http://freeadhocudf.org/>
For us, UDF support should be still in FB 5.
With best regards
Nils Bödeker
Am 18.05.2021 um 23:44 schrieb Adriano dos Santos Fernandes
<[email protected]<mailto:[email protected]>>:
Hi!
UDF was been deprecated in FB 4.
Could we remove them from master for v5?
Also QLI, I believe nobody uses it and there should be no good reason to
maintain it.
I know TCS uses it, so it should be changed.
Adriano
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
__________ Information from ESET Mail Security, version of virus signature
database 23322 (20210519) __________
The message was checked by ESET Mail Security.
http://www.eset.com
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
