Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: DateTime in SQL

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US