BUG #11548: Date insert error - Mailing list pgsql-bugs

From armandogutheil@gmail.com
Subject BUG #11548: Date insert error
Date
Msg-id 20141001145225.17173.38611@wrigleys.postgresql.org
Whole thread Raw
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      11548
Logged by:          Armando Gutheil
Email address:      armandogutheil@gmail.com
PostgreSQL version: 9.3.5
Operating system:   Windows 8
Description:

Hey,

I need to insert a date register without delimiters...

Reading the documentation of postgres, I found it:

http://pgdocptbr.sourceforge.net/pg74/datetime-appendix.html

B1 - Item 3a

But my insert statment is:

Insert into TableName (DataField) Values ('01122014')

That date represents 01/12/2014 ddmmyyy

I changed the 'datestyle' to ISO, DMY, but nothing changes in the insert...

Have the possibility of change this? Is fixed YYYYMMDD format in insert
without delimiters?

Thanks.
Armando Gutheil.

pgsql-bugs by date:

Previous
From: Ashish Gupta
Date:
Subject: I am not able to backup local database.
Next
From: Devrim Gündüz
Date:
Subject: Re: I am not able to backup local database.