Re: substring ..

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: Jeff MacDonald <jeff(at)hub(dot)org>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: substring ..
Date: 2000-12-20 07:42:56
Message-ID: Pine.LNX.3.96.1001220084229.26633B-100000@ara.zf.jcu.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


On Tue, 19 Dec 2000, Jeff MacDonald wrote:

> hi folks..
>
> i want to do this to a datetime field..
>
> select foo from table where substr(datefoo,1,11) = '2000-12-14';

And why not to_char()?

Karel

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message hubert depesz lubaczewski 2000-12-20 13:10:56 how to alter/drop check contraint?
Previous Message Kevin 2000-12-20 04:31:14 How to set autocommit on/off