Results 1 to 3 of 3

Thread: Convert cdrtime

  1. #1
    Join Date
    Jan 2004
    Location
    Slovakia
    Posts
    3

    Unanswered: Convert cdrtime

    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
    Last edited by szabi; 11-27-04 at 06:47.

  2. #2
    Join Date
    Nov 2004
    Posts
    26
    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?

  3. #3
    Join Date
    Jan 2004
    Location
    Slovakia
    Posts
    3

    Thumbs up

    Yes, it helps. Thank you very much.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •