Oninit cdi / Archive
Talk to an expert →

Re: Time zone

Posted in 2006

Topics: Stored Procedures & SPL

SaltTan — — source: Usenet: comp.databases.informix

select dbinfo('get_tz') from table(set{1}) > Krystian wrote: > > Hi, > > > > how to determine in SPL/SQL time zone the client has or the server is > > into? > > It doesn't matter to me which one, as they are both the same. > > I just don't want to create another spl routine just to determine this > > /well i hope i won't have to/. > > > > Best regards, > > Krystian > > I forgot to add: it's informix 9.4

↪ replying to SaltTan
Krystian — — source: Usenet: comp.databases.informix

On Dec 21, 8:08 am, "SaltTan" <Salt...@gmail.com> wrote: > select dbinfo('get_tz') from table(set{1}) > > > Krystian wrote: > > > Hi, > > > > how to determine in SPL/SQL time zone the client has or the server is > > > into? > > > It doesn't matter to me which one, as they are both the same. > > > I just don't want to create another spl routine just to determine this > > > /well i hope i won't have to/. > > > > Best regards, > > > Krystian > > > I forgot to add: it's informix 9.4 Thanks a lot SalTan, that helped. Best regards, Krystian

Glossary