Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Location
    Brussels
    Posts
    57

    Unanswered: datetime interval in SP

    We want to now the execution time of some nightly stored procedure.
    Our test :
    define now1 datetime year to fraction ;
    define now2 datetime year to fraction ;

    select current into now1 from systables where tabid = 1;
    system "sleep 20"
    select current into now2 from systables where tabid = 1;

    While we're expecting an interval, both datetime are equal.

    The same result if the SP calls another SP which return the time.
    Of course our scheduler could do it, but it would be nicer in the SP.

    informix 7.31 aix 4.3
    Someone knows an elegant workaround ?
    Thanks,

    Yves
    Yves & Willy

  2. #2
    Join Date
    Feb 2005
    Posts
    43
    Try this - I believe it will work with IDS 7.31:

    SELECT DBINFO('utc_to_datetime', sh_curtime) AS CURRENT
    FROM sysmaster:sysshmvals;

  3. #3
    Join Date
    Apr 2004
    Location
    Brussels
    Posts
    57
    Ok thanks,
    that's wat I'm looking for.
    Have a nice day.
    Yves & Willy

Posting Permissions

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