Convert cdrtime

szabi · #1 (**permalink**) 11-23-04, 07:35

Hi.

Is there any way to convert cdrtime (integer) to datetime format ? Or what interprets this integer number. If I know, it is number of seconds since 1970.

Thanks

nog · #2 (**permalink**) 11-23-04, 09:25

the sysmaster database has a SP called l2date;

it looks like this,

create procedure l2date ( l int ) returning date;
return trunc((l/86400) + 25568 );
end procedure;

does this help?

szabi · #3 (**permalink**) 11-23-04, 10:14

Yes, it helps. Thank you very much.

Internet Services

Web Development

Digital Marketing

Consumer Tech