Skip site navigation (1) Skip section navigation (2)

Re: date style bug

From: Felipe Alvarez Harnecker <felipe(at)qlsoft(dot)cl>
To: lockhart(at)fourpalms(dot)org
Cc: felipe(dot)alvarez(at)qlsoft(dot)cl, pgsql-bugs(at)postgresql(dot)org
Subject: Re: date style bug
Date: 2001-07-23 16:02:57
Message-ID: 15196.19121.146044.893767@qlsoft.cl (view raw or flat)
Thread:
Lists: pgsql-bugs
Thomas Lockhart writes:
 > > I'm having this bug ramdonly, some time with a "vacuum analyze" goes
 > > away but not always
 > 
 > Likely not related at all.
 > 
 > > obelix3=> set datestyle=postgres,us;
 > > SET VARIABLE
 > > obelix3=> select * from orden_visita where fecha_emision <= 'today'::date;
 > >  numero | corredor | ejecutivo |  remoto   |  cliente  |  retira   | tipo_operac
 > > ion | fecha_emision
 > > --------+----------+-----------+-----------+-----------+-----------+------------
 > > ----+---------------
 > >     292 | 78626380 |   6607775 | 127.0.0.1 |   8779524 |   8779524 |
 > > Venta
 > > QUERY RUNS OK.
 > 
 > What is the value of the fecha_emision column? What is the schema?
 > > 
 > > obelix3=> set datestyle=postgres,euro;
 > > obelix3=> select * from orden_visita where fecha_emision <= 'today'::date;
 > > ERROR:  Bad date external representation '07-17-2001'
 > 
 > What is the schema? I'll guess that fecha_emision is not actually a date
 > type (either date or timestamp) but rather a text field. That is the
 > only way I can think of to provoke an "external representation" error.
 > 
 > More details please.
 > 
 >                       - Thomas
 > 

Here is it:
-------------


obelix3=> \d orden_visita
                                 Table "orden_visita"
   Attribute    |  Type   |                         Modifier                          
----------------+---------+-----------------------------------------------------------
 numero         | integer | not null default nextval('orden_visita_numero_seq'::text)
 corredor       | integer | not null
 ejecutivo      | integer | not null
 remoto         | inet    | not null
 cliente        | integer | not null
 retira         | integer | not null
 tipo_operacion | text    | not null default 'Arriendo'
 fecha_emision  | date    | default date("timestamp"('now'::text))
Index: orden_visita_pkey

-- 
______________________________________________________

Felipe Alvarez Harnecker.  QlSoftware.
		
Tels. 665.99.41 - 09.874.60.17
e-mail: felipe(dot)alvarez(at)qlsoft(dot)cl

http://qlsoft.cl/
http://ql.cl/
______________________________________________________

In response to

pgsql-bugs by date

Next:From: Darko PrenosilDate: 2001-07-23 17:47:14
Subject: Re: [BUGS] WIN32 MULTIBYTE
Previous:From: Thomas LockhartDate: 2001-07-23 15:53:08
Subject: Re: date style bug

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group