BUG #11548: Date insert error

From: armandogutheil(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #11548: Date insert error
Date: 2014-10-01 14:52:25
Message-ID: 20141001145225.17173.38611@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 11548
Logged by: Armando Gutheil
Email address: armandogutheil(at)gmail(dot)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.

Browse pgsql-bugs by date

  From Date Subject
Next Message Devrim Gündüz 2014-10-01 16:43:08 Re: I am not able to backup local database.
Previous Message Tom Lane 2014-10-01 14:22:01 Re: BUG #11457: The below query crashes 9.3.5, but not 9.3.4