What year would your example choose?
The following works in 8.2.4:
select 'Wed Jul 11 2007 10:51:14 GMT+01:00'::timestamp with time zone
timestamptz
2007-07-11 06:51:14-05
It appears to ignore the day of the week, though:
select 'Mon Jul 11 2007 10:51:14 GMT+01:00'
Adam Witney <[EMAIL PROTECTED]> writes:
> Will this make it into the general source tree?
http://archives.postgresql.org/pgsql-committers/2007-06/msg00148.php
regards, tom lane
---(end of broadcast)---
TIP 5: don't forget to
Excellent, thanks very much.
Will this make it into the general source tree? Or would I have to patch
this with future upgrades?
adam
On 12/6/07 16:51, "Tom Lane" <[EMAIL PROTECTED]> wrote:
> Adam Witney <[EMAIL PROTECTED]> writes:
>> In 7.4.12 this would work
>> bugasbase2=# insert into date
Adam Witney <[EMAIL PROTECTED]> writes:
> In 7.4.12 this would work
> bugasbase2=# insert into date_test values('Wed Jul 11 10:51:14 GMT+01:00
> 2001');
Hmm, there's an intentional and an unintentional change here. The
unintentional one is that that field order (tz before year) doesn't work
anym
On Jun 12, 2007, at 4:04 , Adam Witney wrote:
bugasbase_070529=# insert into date_test values('Wed Jul 11 10:51:14
GMT+01:00 2001');
ERROR: invalid input syntax for type date: "Wed Jul 11 10:51:14 GMT
+01:00
2001"
I have found date_trunc and extract in the docs,
Both date_trunc and extr
Hi,
I am upgrading from 7.4.12 to 8.2.4 and I have run into a difference in date
style handling...
In 7.4.12 this would work
bugasbase2=# create table date_test (name date);
CREATE TABLE
bugasbase2=# insert into date_test values('Wed Jul 11 10:51:14 GMT+01:00
2001');
However in 8.2.4 this happ
