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