Re: Insert Into-why doesn't it work?
From: Monica Roman <monicaroman_at_yahoo.com>
Date: 1 May 2003 07:45:33 -0700
Message-ID: <9eb77af5.0305010645.3d70261f_at_posting.google.com>
Date: 1 May 2003 07:45:33 -0700
Message-ID: <9eb77af5.0305010645.3d70261f_at_posting.google.com>
Michael,
mvk_at_servocomp.ru (Michael Kuznetsov) wrote in message
> ... You try to select all rows with date 28 April 2003 with any time. For
> example:
> 28-APR-03 09:15am
> 28-APR-03 11:00pm
> etc. Correct?
YES!!!! you got it.
> For this is better to use trim() function:
> WHERE trim(Field1) = to_date('28-APR-03');
For a newbie like me, a clear explanation is the best! So thank you so much!
Monica Received on Thu May 01 2003 - 16:45:33 CEST