[rt-users] RT 2.0.3 and Dates

[Jesse]

I'd be curious to know if the following improves things:

in DBIx/SearchBuilder/Handle/Pg, there's a line:

    $self->SimpleQuery("SET TIME ZONE 'GMT'");

After this line, add the line:

    $self->SimpleQuery("SET DATESTYLE 'ISO'");



On Wed, Jul 25, 2001 at 12:53:05PM +0100, Feargal Reilly wrote:
> Hi,
> I can tell you your problem - the postgres DATESTYLE variable is set to something other than ISO - at present RT only knows how to deal with this.
> To confirm this,
> % psql rt2
> rt2=> show datestyle;
> This will give you the current datestyle in use, you'll see it's probably Postgres.
> 
> Workaround:
> To change it, edit ~pgsql/.profile, set the variable PGDATESTYLE=ISO and restart postgres. This'll change the datestyle for all your dbs though.
> 
> Fix:
> I hope to get time to fix this by the end of the week, unless Jesse gets around to it first.
> 
> -Feargal.
> 
> On Tue, 24 Jul 2001 15:43:08 -0700
> "Rob" <falcon at rasterburn.com> wrote:
> 
> > Hi there.  I recently installed 2.0.3 and upon playing, I see "Not set"
> > everywhere a time and date should be.    Everything else seems to work...
> > 
> > System config:
> > 
> > Solaris 8 x86
> > Apache 1.3.20 + mod_perl 1.26
> > Perl 5.6.1
> > Postgres 7.1.2
> > testdeps passes without a problem
> > 
> > Little help?
> > 
> > Rob
> > 
> > 
> > 
> > 
> > _______________________________________________
> > rt-users mailing list
> > rt-users at lists.fsck.com
> > http://lists.fsck.com/mailman/listinfo/rt-users
> > 
> 
> 
> -- 
> Feargal Reilly,
> Systems Administrator,
> The CIA.
> 



-- 
jesse reed vincent -- root at eruditorum.org -- jesse at fsck.com 
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

"If IBM _wanted_ to make clones, we could make them cheaper and faster than
anyone else!"  - An IBM Rep. visiting Vassar College's Comp Sci Department.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 240 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20010725/89433523/attachment.sig>