Re: to_date conversion semantics?

From: "Colin 't Hart" <colinthart(at)gmail(dot)com>
To: adrian(dot)klaver(at)gmail(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: to_date conversion semantics?
Date: 2010-09-20 14:50:02
Message-ID: AANLkTi=HOP=FZQXZeqCNE8k2oY9mzG-NWUPawOkb9K-F@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I must be blind, I can see the syntax but I can't see where it explains the
wrapping phenomenon that I'm seeing.

Cheers,

Colin

On 20 September 2010 16:36, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> wrote:

> On Monday 20 September 2010 7:20:29 am Colin 't Hart wrote:
> > Hi,
> >
> > I can't find in the Postgresql documentation the semantics that explains
> > the following:
> >
> >
> > colin(at)ruby:~/workspace/eyedb$ psql
> > psql (8.4.4)
> > Type "help" for help.
> >
> > colin=> select to_date('731332', 'YYMMDD');
> > to_date
> > ------------
> > 1974-02-01
> > (1 row)
> >
> > colin=>
> >
> >
> > Thanks,
> >
> > Colin
>
> http://www.postgresql.org/docs/8.4/interactive/functions-formatting.html
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)gmail(dot)com
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Ribe 2010-09-20 14:56:59 Re: where does postgres keep the query result until it is returned?
Previous Message Adrian Klaver 2010-09-20 14:36:00 Re: to_date conversion semantics?