Re: [GENERAL] Timestamp with timezone output

Ok, it seems the Daylight Savings Time is perfect explanation to me. Thanks y'all, you're the best ! *--* *Arnaud Becher* Paris - San Francisco 10 rue du Faubourg Poissonnière - 75010 Paris T. + 33 (0)6 17 15 52 43 http://www.inovia.fr <

Re: [GENERAL] Timestamp with timezone output

On Wed, May 25, 2016 at 9:47 AM, Arnaud Inovia Team wrote: > While using "psql", when selecting a column timestamp with > timezone, I get results with different timezones: > > -[ RECORD 6 ]---+--- > expiration_date | 2015-09-07 00:00:00+02 > -[ RECORD 7 ]---+--

Re: [GENERAL] Timestamp with timezone output

Hi, Le 25 mai 2016 4:50 PM, "Arnaud Inovia Team" a écrit : > > I have some question regarding some timezone behaviour. > > Documentation is saying: > > > When a timestamp with time zone value is output, it is always converted from UTC to the current timezone zone, and displayed as local time in t

Re: [GENERAL] Timestamp with timezone output

On 2016-05-25 09:47, Arnaud Inovia Team wrote: > I have some question regarding some timezone behaviour. > > Documentation is saying: >> When a timestamp with time zone value is output, it is always converted from >> UTC to the current timezone zone, and displayed as local time in that zone.

[GENERAL] Timestamp with timezone output

I have some question regarding some timezone behaviour. Documentation is saying: > When a timestamp with time zone value is output, it is always converted from UTC to the current timezone zone, and displayed as local time in that zone. To see the time in another time zone, either change timezone

Re: [GENERAL] timestamp with timezone and time zone name

On 08/07/2012 08:36 PM, Shridhar Daithankar wrote: On Tuesday 07 Aug 2012 12:21:04 AM Tom Lane wrote: > Shridhar Daithankar writes: > > I am wondering, why following two values result in a shift by 3.5 hours. I > > would expect them to be identical. > > > > I understand that canonical ti

Re: [GENERAL] timestamp with timezone and time zone name

On Tuesday 07 Aug 2012 12:21:04 AM Tom Lane wrote: > Shridhar Daithankar writes: > > I am wondering, why following two values result in a shift by 3.5 hours. I > > would expect them to be identical. > > > > I understand that canonical time zone names could be ambiguous at times > > but I think IS

Re: [GENERAL] timestamp with timezone and time zone name

Shridhar Daithankar writes: > I am wondering, why following two values result in a shift by 3.5 hours. I > would expect them to be identical. > I understand that canonical time zone names could be ambiguous at times but I > think IST is not one of them. I don't know why you'd think that ... sr

[GENERAL] timestamp with timezone and time zone name

Hello, I am wondering, why following two values result in a shift by 3.5 hours. I would expect them to be identical. I understand that canonical time zone names could be ambiguous at times but I think IST is not one of them. Any explanation? --- test=# select '2012-08-07 05:24:56.

Re: [GENERAL] Timestamp with timezone query

CTED] Sent: Tuesday, September 26, 2006 12:47 AM To: Harry Hehl; pgsql-general@postgresql.org Subject: RE: [GENERAL] Timestamp with timezone query I'm not at my dev station to check, but what about: SELECT myTime AT TIME ZONE 'UTC' FROM theTable; Then try: SELECT myTime AT TI

Re: [GENERAL] Timestamp with timezone query

Title: RE: [GENERAL] Timestamp with timezone query I'm not at my dev station to check, but what about: SELECT myTime AT TIME ZONE 'UTC' FROM theTable; Then try: SELECT myTime AT TIME ZONE 'UTC' FROM theTable WHERE myTime = '19:30:00-00'; Or: SELECT myTi

Re: [GENERAL] Timestamp with timezone query

lto:[EMAIL PROTECTED] On Behalf Of Harry Hehl Sent: Monday, September 25, 2006 5:34 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] Timestamp with timezone query Thanks, that does it. select * from table where column = '2006-02-10 19:30:00' AT TIME ZONE 'utc'; I al

Re: [GENERAL] Timestamp with timezone query

results or syntax errors. Is there a way to do the same thing with TIME columns? -Original Message- From: Brandon Aiken [mailto:[EMAIL PROTECTED] Sent: Monday, September 25, 2006 11:39 AM To: Harry Hehl; pgsql-general@postgresql.org Subject: RE: [GENERAL] Timestamp with timezone qu

Re: [GENERAL] Timestamp with timezone query

, September 25, 2006 11:06 AM To: pgsql-general@postgresql.org Subject: [GENERAL] Timestamp with timezone query Hello, I have a table with TIMESTAMP WITH TIMEZONE column. I would like to query for a timestamp using a different timezone. For example if a column contains '2006-02-11 00:30:00-05

[GENERAL] Timestamp with timezone query

Hello, I have a table with TIMESTAMP WITH TIMEZONE column. I would like to query for a timestamp using a different timezone. For example if a column contains '2006-02-11 00:30:00-05' select * from table where column='2006-02-10 19:30:00+00' would return the column containing '2006-02-11 00:30:00

Re: [GENERAL] Timestamp with Timezone

Matthew Terenzio wrote: reading the docs . . . let's see if I've got it. 1. Timestamp with timezone accepts a timestamp with the additional timezone, converts it and stores it as GMT 2. It returns the value as the timestamp converted to the timezone of the local machine? that's what it says

[GENERAL] Timestamp with Timezone

reading the docs . . . let's see if I've got it. 1. Timestamp with timezone accepts a timestamp with the additional timezone, converts it and stores it as GMT 2. It returns the value as the timestamp converted to the timezone of the local machine? ---(end of broadcas

[GENERAL] Timestamp with Timezone

I recently upgraded an application from postgresql 7.4.2 to 7.4.5, and now I am having timezone nightmares. I checked on the old server, and found that in the postgresql.conf, the timezone was set for unknown. The timezone portion of the records was being set to GMT+06 ( for reference, I am in