Re: [SQL] substring ..

[Karel Zak]

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