[rt-users] RT 2.0.3 and Dates

Feargal Reilly feargal at thecia.ie
Wed Jul 25 16:39:31 EDT 2001


On Wed, 25 Jul 2001 12:21:01 -0700
"Rob" <falcon at rasterburn.com> wrote:

> Right.  I tracked this down to PGDATESTYLE.  But I don't think this is a
> postgres issue.  RT2 assumes that the date styles 'sql' and 'iso' are the
> same, but in postgres they are not.
> 
> The fix you suggest will NOT work for as I have other applications depending
> on the datasytle being 'SQL' and not ISO.

Actually, it should work, because the datestyle is only set for that connection/session. New connections from other apps will still have your default datestyle.
 
> The better solution for this would be to SET DATESTYLE TO 'ISO' somewhere
> within RT2 and recreate the database.  As soon as I find the right place,
> I'll send in a patch.
> 
> Rob
> 
> ----- Original Message -----
> From: "Feargal Reilly" <feargal at thecia.ie>
> To: <rt-users at lists.fsck.com>
> Sent: Wednesday, July 25, 2001 4:53 AM
> Subject: Re: [rt-users] RT 2.0.3 and Dates
> 
> 
> 
> 
> _______________________________________________
> 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/0f53ba07/attachment.sig>


More information about the rt-users mailing list