Oninit cdi / Archive
Talk to an expert →

Time zone

Posted in 2006

Topics: Stored Procedures & SPL

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

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

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

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 Krystian
Art S. Kagel — — source: Usenet: comp.databases.informix

Krystian wrote: > 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 Write a 'C' UDR to check the server's timezone by calling getenv('TZ'). As to checking the user's timezone - part of the client's environment is sent as part of the connection handshaking, so it may be available, but I don't see and way in the DataBlade API Function Reference manual to get at it. Art S. Kagel

Glossary