From: Bruno Wolff III <bruno@wolff.to>
To: Richard Rowell <richard@bowmansystems.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: to_date() confusion
Date: Wed, 8 Jan 2003 09:06:03 -0600
Message-ID: <20030108150603.GB27870@wolff.to> (raw)
In-Reply-To: <1042037339.25939.63.camel@localhost>
References: <1042037339.25939.63.camel@localhost>
On Wed, Jan 08, 2003 at 08:49:00 -0600,
Richard Rowell <richard@bowmansystems.com> wrote:
> I'm confused. How do I massage the integer 10102 into the date
> 2002-01-01?
>
> cmi=> select to_char(10102,'000000');
> to_char
> ---------
> 010102
> (1 row)
Note the leading space in the returned row. That is probably what is making
the difference. You probably want to use to_char(10102,'FM000000').
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bruno@wolff.to, richard@bowmansystems.com
Subject: Re: to_date() confusion
In-Reply-To: <20030108150603.GB27870@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox