now() AT TIME ZONE 'GMT'; 
Author Message
 now() AT TIME ZONE 'GMT';

(on -hackers)

> If you apply the AT TIME ZONE operator to a TIMESTAMP WITH TIME ZONE
> value, what happens is the internal GMT value is rotated to the
> specified zone and then the output is labeled as type TIMESTAMP WITHOUT
> TIME ZONE, preventing any further automatic zone rotations.

Hmm. That is how it probably *should* work, but at the moment the
timestamptz_zone() function actually outputs a character string! That is
a holdover from previous versions which did not have a "no zone"
timestamp; it would seem now to be more appropriate to output a no-zone

I'll look at changing this in my upcoming patch set...

                    - Thomas

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?


Sat, 25 Sep 2004 14:23:41 GMT
 [ 1 post ] 

 Relevant Pages 

1. now() AT TIME ZONE 'GMT';

2. Time zones - convert local time to GMT

3. to_char(now(), 'YYYY') and time zones

4. CASE not working - I'm converting time zone data

5. Building multi time zones supported Db's

6. run-time error '3170': Couldn't fin installable ISAM

7. HELP converting a GMT to anyother Zone

8. **************!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!Help me !!!!!!!!!!!!!!!!!!!!!!!!'''''''''''''''''''''''*************

9. Visual Basic's Programs Exchanging Zone

10. converting PST/PDT time to GMT time

11. GMT time to local server time

12. GMT - Standard Time/Daylight Time

Powered by phpBB® Forum Software