Re: Problem with to_date function

On Monday 22 August 2005 15:31, Gilberto C Andrade wrote:
> Hi,
>
> I would like to know if the following is the expected result:
> from psql:
> bcoproducao=# select to_date(current_date, 'DD/MM/YYYY'), current_date;
>   to_date   |    date
> ------------+------------
>  22/08/2005 | 22/08/2005
> (1 row)
>
> from my jdbc code:
>             rs = stmt.executeQuery("select to_date(current_date,
> 'DD/MM/YYYY'), current_date");
>             while (rs.next()) {
>                 System.out.println(rs.getString(1) + " | "
> +rs.getString(2));
>             }
> result:
>             0028-01-26 | 2005-08-22

Hate to burst your bubble:

psql=# select to_date(current_date, 'DD/MM/YYYY'), current_date;
  to_date   |    date
------------+------------
 0028-01-26 | 2005-08-22
(1 row)

So there is something fishy with your use of to_date, most likely because
current_date is already of type DATE, and TO_DATE expects a string as it's
first parameter.

Lemme see:

psql=# select cast( current_date as text );
    text
------------
 2005-08-22
(1 row)

psql=# select to_date( '2005-08-22', 'DD/MM/YYYY');
  to_date
------------
 0028-01-26
(1 row)

So there you have it...

I think that basically you don't need that to_date at all, since you already
have a date...

JdV!!

>
> Any advice here?
> Thanks!
> Gilberto
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq

--
--------------------------------------------------------------
Jan de Visser                     jdevisser@digitalfairway.com

                Baruk Khazad! Khazad ai-menu!
--------------------------------------------------------------