#$@%#$%!

Ngiler SH3LL 360
: / lib64 / firebird / plugins / udr /

Information Server
MySQL : OFF Perl : OFF CURL : ON WGET : OFF PKEXEC : OFF

Directive	Local Value
IP Address	162.0.209.101
System	Linux premium169.web-hosting.com 4.18.0-553.50.1.lve.el8.x86_64 #1 SMP Thu Apr 17 19:10:24 UTC 2025 x86_64
User	luxeelil
PHP Version	8.0.30
Software	LiteSpeed
Doc root	Writable

Edit File : udf_compat.sql \| Size : 1.35 KB
-- 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; Back

Edit File : udf_compat.sql | Size : 1.35 KB

-- 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;

Back