Re: DateTime in SQL

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 30 Dec 1999 08:06:51 GMT
Message-ID: <386b122e.820621@news.demon.nl>

On Wed, 29 Dec 1999 22:36:23 -0800, "Bob Johnson" <robertsj_at_best.com> wrote:

>I would like to filter a select statement by using date and time:
>select * where datefield = to_date('12/28/99 19:00:00')
>But, this doesn't work. How do I do this? Thanks, Bob
>
>

In your statement
to_date('12/28/99 19:00:00','MM/DD/YY HH24:MI:SS')

Sorry to say so, but this a truly typical RTFM question.

Hth,

Sybrand Bakker, Oracle DBA Received on Thu Dec 30 1999 - 02:06:51 CST