Results 1 to 5 of 5

Thread: l2date

  1. #1
    Join Date
    Nov 2008
    Posts
    18

    Unanswered: l2date

    hi all,

    i got recently stuck up with informix XPS

    select sid ,
    username ,
    pid ,
    hostname ,
    l2date(connected)
    from syssessions
    order by 5;

    674: Routine (l2date) can not be resolved.
    111: ISAM error: no record found.


    is l2date not present in informix XPS
    if not what is the alternative...
    got so used to l2date



    Thanks in advance .....

  2. #2
    Join Date
    Nov 2008
    Posts
    18
    is l2date supported on XPS or i am having some error with my setup?

  3. #3
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi,
    Please, check on "$INFORMIXDIR/etc/sysmaster.sql" for l2date.

    Gustavo.

  4. #4
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    I never work with XPS, I don't know if this will work

    Code:
    select sid ,
    username ,
    pid ,
    hostname ,
    l2date(connected),
    dbinfo('utc_to_datetime',connected),
    extend(dbinfo('utc_to_datetime',connected), year to day)
    from syssessions
    order by 5;
    Be careful , because the l2date round the result, the dbinfo don't
    A example of the output:
    Code:
    sid           18
    username      informix
    pid           0
    hostname
    (expression)  28/08/09
    (expression)  2009-08-27 22:16:19
    (expression)  2009-08-27
    
    sid           17
    username      informix
    pid           0
    hostname
    (expression)  28/08/09
    (expression)  2009-08-27 22:16:19
    (expression)  2009-08-27
    here my locale is pt_BR , because this my date format is DD/MM/YY
    ________________________________________
    César Inacio Martins
    Jundiai / SP - Brasil
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - English (translated by Google).
    ________________________________________

  5. #5
    Join Date
    Nov 2008
    Posts
    18
    $INFORMIXDIR/etc/sysmaster.sql doenst contain l2date..
    will try dbinfo and update here

Posting Permissions

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