| Server IP : 172.67.174.47 / Your IP : 216.73.216.145 Web Server : LiteSpeed System : Linux premium151.web-hosting.com 4.18.0-553.44.1.lve.el8.x86_64 #1 SMP Thu Mar 13 14:29:12 UTC 2025 x86_64 User : tempvsty ( 647) PHP Version : 8.0.30 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /././proc/self/root/proc/thread-self/root/proc/self/root/lib64/firebird/plugins/udr/ |
Upload File : |
-- Create functions in current DB
create function div (
n1 integer,
n2 integer
) returns double precision
external name 'udf_compat!UC_div'
engine udr;
create function frac (
val double precision
) returns double precision
external name 'udf_compat!UC_frac'
engine udr;
create function dow (
val timestamp
) returns varchar(53) character set none
external name 'udf_compat!UC_dow'
engine udr;
create function sdow (
val timestamp
) returns varchar(13) character set none
external name 'udf_compat!UC_sdow'
engine udr;
create function getExactTimestampUTC
returns timestamp
external name 'udf_compat!UC_getExactTimestampUTC'
engine udr;
create function isLeapYear (
val timestamp
) returns boolean
external name 'udf_compat!UC_isLeapYear'
engine udr;
-- Run minimum test
select 25, 3, div(25, 3) from rdb$database;
select pi(), frac(pi()) from rdb$database;
select timestamp '2020-01-29', dow(timestamp '2020-01-29'), sdow(timestamp '2020-01-29') from rdb$database;
set time zone 'utc';
select cast(((current_timestamp - getexacttimestamputc()) * 1000) as integer) as getexacttimestamptest from rdb$database;
set time zone local;
select timestamp '2019-01-29', isleapyear(timestamp '2019-01-29') from rdb$database;
select timestamp '2020-01-29', isleapyear(timestamp '2020-01-29') from rdb$database;