Postgres Pro
Downloads
Home   >   mailing lists

Re: substring .. - Mailing list pgsql-sql

From Karel Zak
Subject Re: substring ..
Date
Msg-id Pine.LNX.3.96.1001220084229.26633B-100000@ara.zf.jcu.cz
Whole thread Raw
In response to substring ..  (Jeff MacDonald <jeff@hub.org>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "Robert B. Easter"
Date:
Subject: Re: substring ..
Next
From: hubert depesz lubaczewski
Date:
Subject: how to alter/drop check contraint?