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

Re: to_date bug

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: Jeff <jeff(at)downtown-office(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org, lockhart(at)alumni(dot)caltech(dot)edu
Subject: Re: to_date bug
Date: 2002-06-17 09:08:32
Message-ID: 20020617110831.A15439@zf.jcu.cz (view raw or flat)
Thread:
Lists: pgsql-bugs
On Wed, Jun 12, 2002 at 10:54:53AM -0600, Jeff wrote:
> 
> select to_date('December 12 2002','Month dd yyyy');
>   to_date   
> ------------
>  2002-12-02
> 
> select to_date('January 12 2002','Month dd yyyy');        
>   to_date   
> ------------
>  0005-06-24     <----- Problem right there.

 Please, see docs...

test=# select to_date('January   12 2002','Month dd yyyy');
                              ^^
  to_date   
------------
 2002-01-12

test=# select to_date('January 12 2002','FMMonth dd yyyy');
                                         ^^
  to_date   
------------
 2002-01-12

 I try prepare it more robus for 7.3.

    Karel

-- 
 Karel Zak  <zakkr(at)zf(dot)jcu(dot)cz>
 http://home.zf.jcu.cz/~zakkr/
 
 C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

In response to

pgsql-bugs by date

Next:From: Aaron MulderDate: 2002-06-17 13:52:21
Subject: JDBC Metadata Problems
Previous:From: Tom LaneDate: 2002-06-17 03:27:39
Subject: Re: classful cidr insertion bug?

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