l2date

Blackprince · #1 (**permalink**) 08-25-09, 23:20

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

Blackprince · #2 (**permalink**) 08-27-09, 10:41

is l2date supported on XPS or i am having some error with my setup?

gurey · #3 (**permalink**) 08-27-09, 16:21

Hi,
Please, check on "$INFORMIXDIR/etc/sysmaster.sql" for l2date.

Gustavo.

ceinma · #4 (**permalink**) 08-27-09, 21:26

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

Blackprince · #5 (**permalink**) 08-29-09, 01:32

$INFORMIXDIR/etc/sysmaster.sql doenst contain l2date..
will try dbinfo and update here

Internet Services

Web Development

Digital Marketing

Consumer Tech