Thread: BUG #11548: Date insert error

BUG #11548: Date insert error

From
armandogutheil@gmail.com
Date:
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.