Problem with data format

Поиск
Список
Период
Сортировка
Искать

Problem with data format

От:
"Dario Ottaviano" <dario_ottaviano@togliquestovirgilio.it>
Дата:
Hi, i use Postgresql 7.2 on a windows server (Win 2000 Server).
The problem is that when i write a date into a timestamp field of a table,
it writes it in to No-Europe format.

So, for istance, if i write the date: 04/03/2004 (4 Mar 2004), it writes the
date 03/04/2004 (3 Apr 2004) into the table .

Why?
Is there a way to avoid this?

Tanck you for help!
Dario




Re: Problem with data format

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
"Dario Ottaviano"  writes:
> So, for istance, if i write the date: 04/03/2004 (4 Mar 2004), it writes the
> date 03/04/2004 (3 Apr 2004) into the table .

You need to change the DateStyle setting to agree with your desired
format.

			regards, tom lane

Re: Problem with data format

От:
"scott.marlowe" <scott.marlowe@ihs.com>
Дата:
On Sat, 6 Mar 2004, Dario Ottaviano wrote:

> Hi, i use Postgresql 7.2 on a windows server (Win 2000 Server).
> The problem is that when i write a date into a timestamp field of a table,
> it writes it in to No-Europe format.

7.2 had some issues with accepting the wrong date formats and just 
mangling them until they fit, whether it made sense or not (i.e. you could 
insert a date of the format 2003-22-03, which should be illegal, and it 
would swap it around and insert 2003-03-22)  The fixes are in 7.3 and 
later, I'd suggest upgrading to 7.4.x if you want proper bounds checking 
on dates.

> So, for istance, if i write the date: 04/03/2004 (4 Mar 2004), it writes the
> date 03/04/2004 (3 Apr 2004) into the table .

while 7.2 allows you to set a european or US date style, it will gladly 
swap months and days to get a date it can insert.  Better, in my opinion, 
to use 7.3/7.4 which enforce the date style you set.

Re: Problem with data format

От:
"Dario Ottaviano" <dario_ottaviano@togliquestovirgilio.it>
Дата:
That's ok, but how can i do that?
I tried something like "Set datestyle='European', but nothing changed!

Please, can you help me!
Thank you,
Dario Ottaviano


"Tom Lane"  ha scritto nel messaggio
news:14254.1078551909@sss.pgh.pa.us...
> "Dario Ottaviano"  writes:
> > So, for istance, if i write the date: 04/03/2004 (4 Mar 2004), it writes
the
> > date 03/04/2004 (3 Apr 2004) into the table .
>
> You need to change the DateStyle setting to agree with your desired
> format.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>


Re: Problem with data format

От:
"scott.marlowe" <scott.marlowe@ihs.com>
Дата:
What version of Postgresql are you running.  Versions 7.2 and before would 
gladly swap around day / month when they needed to be to fit, and this 
caused me a few headaches where I had data feeds that were partially 
failing and couldn't figure out why.

On Sat, 6 Mar 2004, Dario Ottaviano wrote:

> That's ok, but how can i do that?
> I tried something like "Set datestyle='European', but nothing changed!
> 
> Please, can you help me!
> Thank you,
> Dario Ottaviano
> 
> 
> "Tom Lane"  ha scritto nel messaggio
> news:14254.1078551909@sss.pgh.pa.us...
> > "Dario Ottaviano"  writes:
> > > So, for istance, if i write the date: 04/03/2004 (4 Mar 2004), it writes
> the
> > > date 03/04/2004 (3 Apr 2004) into the table .
> >
> > You need to change the DateStyle setting to agree with your desired
> > format.
> >
> > regards, tom lane
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> >                http://archives.postgresql.org
> >
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
>                http://archives.postgresql.org
> 

FAQ