[rt-users] RT 2.0.3 and Dates

[Feargal Reilly]

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.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 230 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20010725/b44f97e1/attachment.sig>