Re: [ADMIN] timezone, how postgres deal with it?

Anibal David Acosta wrote: > This query returns false > > select ('2012-11-20 17:00:00-02:00'::timestamp with time zone) = ('2012-11-20 18:00:00- > 03:00'::timestamp with time zone) > > But are exactly same time > > Why? They are not the same. Compare: select ('2012-11-20 17:00:00-02:00'::tim

Re: [ADMIN] timezone, how postgres deal with it?

"Anibal David Acosta" writes: > This query returns false > select ('2012-11-20 17:00:00-02:00'::timestamp with time zone) = > ('2012-11-20 18:00:00-03:00'::timestamp with time zone) > But are exactly same time No, they aren't. You're apparently still confused about the sign of timezone offsets.

[ADMIN] timezone, how postgres deal with it?

This query returns false select ('2012-11-20 17:00:00-02:00'::timestamp with time zone) = ('2012-11-20 18:00:00-03:00'::timestamp with time zone) But are exactly same time Why? timestamp with timezone just show/hide time zone? thanks

[ADMIN] FW: [webmaster] Information Required

Hi ! Please provide me a link psqlodbc driver 64-bit for Windows Server 2012. Regards Shamim Uddin Mob: 9958860528 ___ Coming together is a beginning; keeping together is a progress; working together is a success. > Date