IDS Forum

RE: "AT TIME ZONE"

Posted By: Clifton Bean
Date: Tuesday, 15 December 2009, at 10:34 a.m.

In Response To: Re: "AT TIME ZONE" (Art Kagel)

Art:

You misread what I was sayin'.

I was basically wondering "out loud" about a possible FEATURE REQUEST to IBM Informix.

Take care.

Clifton

> To: ids@iiug.org
> From: art.kagel@gmail.com
> Subject: Re: "AT TIME ZONE" [18371]
> Date: Mon, 14 Dec 2009 09:25:16 -0500
>
> No! Whatever time you store the server ASSUMES that it is in local time.
> It does not conversions from TZ at all.
>
> Art
>
> Art S. Kagel
> Oninit (www.oninit.com)
> IIUG Board of Directors (art@iiug.org)
>
> See you at the 2010 IIUG Informix Conference
> April 25-28, 2010
> Overland Park (Kansas City), KS
> www.iiug.org/conf
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions and
> do not reflect on my employer, Oninit, the IIUG, nor any other organization
> with which I am associated either explicitly or implicitly. Neither do
> those opinions reflect those of other individuals affiliated with any entity
> with which I am affiliated nor those of the entities themselves.
>
> On Mon, Dec 14, 2009 at 8:32 AM, Clifton Bean <clifton_bean@hotmail.com>wrote:
>
> > So is it worth having the engine store all datetimes as timezone GMT+0 and
> > when the datetime is needed from a transaction it displays the datetime in
> > local server time, unless overriden by an environment variable?
> >
> > Take care.
> >
> > Clifton
> >
> > > To: ids@iiug.org
> > > From: jleffler.iiug@gmail.com
> > > Subject: Re: RE: "AT TIME ZONE" [18369]
> > > Date: Mon, 14 Dec 2009 02:42:03 -0500
> > >
> > > On Tue, Dec 8, 2009 at 10:02, DAVE GRIFFEN <dgriffen@finishline.com>
> > wrote:
> > >
> > > > No need to load current time zone into a table. It is readily
> > available...
> > > >
> > > > select dbinfo('get_tz')
> > > > from systables
> > > > where tabid = 1
> > > >
> > >
> > > Although this returns the time zone of the client, that value is ignored
> > in
> > > the server. All server time computations are performed in the time zone
> > of
> > > the server.
> > >
> > > --
> > > Jonathan Leffler #include <disclaimer.h>
> > > Email: jleffler@earthlink.net, jleffler@us.ibm.com
> > > Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/
> > > "Blessed are we who can laugh at ourselves, for we shall never cease to
> > be
> > > amused."
> > > NB: Please do not use this email for correspondence.
> > > I don't necessarily read it every week, even.
> > > Jonathan
> > > Swift<http://www.brainyquote.com/quotes/authors/j/jonathan_swift.html>
> > > - "May you live every day of your life."
> > >
> > > --000e0cd11310871b8b047aab689c
> > >
> > >
> > >
> >
> >
> *******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> >
> > _________________________________________________________________
> > Hotmail: Trusted email with Microsoft’s powerful SPAM protection.
> > http://clk.atdmt.com/GBL/go/177141664/direct/01/
> >
> >
> >
> >
> *******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --000e0ce0f92886d20c047ab10ab5
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>

_________________________________________________________________
Hotmail: Free, trusted and rich email service.
http://clk.atdmt.com/GBL/go/171222984/direct/01/

Messages In This Thread

• "AT TIME ZONE"
  Adam Tauno Williams -- Monday, 7 December 2009, at 9:49 a.m.
  • Re: "AT TIME ZONE"
    Art Kagel -- Monday, 7 December 2009, at 4:09 p.m.
    • RE: "AT TIME ZONE"
      Everett Mills -- Monday, 7 December 2009, at 4:40 p.m.
      • Re: RE: "AT TIME ZONE"
        DAVE GRIFFEN -- Tuesday, 8 December 2009, at 1:02 p.m.
        • Re: RE: "AT TIME ZONE"
          Art Kagel -- Tuesday, 8 December 2009, at 2:51 p.m.
          • RE: RE: "AT TIME ZONE"
            Everett Mills -- Tuesday, 8 December 2009, at 4:25 p.m.
            • Re: RE: "AT TIME ZONE"
              Art Kagel -- Tuesday, 8 December 2009, at 4:36 p.m.
        • Re: RE: "AT TIME ZONE"
          Jonathan Leffler -- Monday, 14 December 2009, at 2:42 a.m.
          • RE: "AT TIME ZONE"
            Clifton Bean -- Monday, 14 December 2009, at 8:32 a.m.
            • Re: "AT TIME ZONE"
              Art Kagel -- Monday, 14 December 2009, at 9:25 a.m.
              • RE: "AT TIME ZONE"
                Konikoff, Robert W MAJ RET -- Tuesday, 15 December 2009, at 10:06 a.m.
                • RE: "AT TIME ZONE"
                  Adam Tauno Williams -- Tuesday, 15 December 2009, at 11:28 a.m.
                • Re: "AT TIME ZONE"
                  Art Kagel -- Tuesday, 15 December 2009, at 12:14 p.m.
                  • RE: "AT TIME ZONE"
                    Konikoff, Robert W MAJ RET -- Tuesday, 15 December 2009, at 12:50 p.m.
              • RE: "AT TIME ZONE"
                Clifton Bean -- Tuesday, 15 December 2009, at 10:34 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.