On Sunday 19 July 2009 10:59:24 pm Dennis Gearon wrote:
> Hey Tom,
> I was trying to use 'US/Pacific-New' as my long, unabbreviated
> timezone and it wasn't working. I thought postgres wasn't accepting the
> unabbreviated, geopolitical, daylight savings time, time zones. Turns out,
> the serve
> I just have to read more on how to get it out relative to a different
> time zone than it went in. I'll find it.
Sounds like a job for SELECT ... AT TIME ZONE ...;
Karsten
--
Neu: GMX Doppel-FLAT mit Internet-Flatrate + Telefon-Flatrate
für nur 19,99 Euro/mtl.!* http://portal.gmx.net/de/g
the movie - 'Syriana'
--- On Sun, 7/19/09, Tom Lane wrote:
> From: Tom Lane
> Subject: Re: [GENERAL] timestamp with time zone tutorial
> To: "Dennis Gearon"
> Cc: pgsql-general@postgresql.org
> Date: Sunday, July 19, 2009, 8:00 PM
> Dennis Gearon
> writes:
&
Dennis Gearon writes:
> What I want is to be able to insert into my project's database, times
> given by anybody anywhere on the planet (the SUBMITTER), add the appropriate
> timezone in the insert statement so that it in 'GMT/UMT' neutral'. I believe
> this is the way Postgres does it, st
raphical location of the SUBMITTER.
> From: Adrian Klaver
> Subject: Re: [GENERAL] timestamp with time zone tutorial
Dennis Gearon wrote:
> > None of the examples of converting a string
> to_timestamp() show using a
> > time zone input as an input.Does it allow full length
On Sunday 19 July 2009 6:41:24 pm Dennis Gearon wrote:
> None of the examples of converting a string to_timestamp() show using a
> time zone input as an input.Does it allow full length timezones for
> daylight savings time at the timestamp instant in time, or just an
> abbreviation for a fixed offs
rom: Adrian Klaver
> Subject: Re: [GENERAL] timestamp with time zone tutorial
> To: "Dennis Gearon"
> Cc: pgsql-general@postgresql.org
> Date: Sunday, July 19, 2009, 5:15 PM
> On Sunday 19 July 2009 4:56:09 pm
> Dennis Gearon wrote:
> > I read it better, and
On Sunday 19 July 2009 4:56:09 pm Dennis Gearon wrote:
> I read it better, and it makes more sense now.
>
> But,
> I'd like it to show how to insert:
> 'strings' - which it does
> timestampz value -->using to_timestampz(...)
For above:
http://www.postgresql.org/docs/8.4/interactive/functio
I read it better, and it makes more sense now.
But,
I'd like it to show how to insert:
'strings' - which it does
timestampz value -->using to_timestampz(...)
integers::timestampz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subsc
On Sun, Jul 19, 2009 at 01:29:14PM -0700, Dennis Gearon wrote:
> INSERTing timestampz, 'to_timestamp', output formatting, input formatting,
> SERVER TIME, USER_LOCAL_TIME, multi timezone applications.
>
> Anyone wonder how those all work? **I** sure do!!!
The official docs[1,2] have generally be
On Sunday 19 July 2009 1:29:14 pm Dennis Gearon wrote:
> INSERTing timestampz, 'to_timestamp', output formatting, input formatting,
> SERVER TIME, USER_LOCAL_TIME, multi timezone applications.
>
> Anyone wonder how those all work? **I** sure do!!!
>
> Is there a tutorial anywhere on how to do all t
INSERTing timestampz, 'to_timestamp', output formatting, input formatting,
SERVER TIME, USER_LOCAL_TIME, multi timezone applications.
Anyone wonder how those all work? **I** sure do!!!
Is there a tutorial anywhere on how to do all those? Can anyone who is
knowledgeable about this:
(1) Po
12 matches
Mail list logo
