Xref: alice comp.databases.oracle.misc:50264
Path: alice!news-feed.fnsi.net!newspump.monmouth.com!newspeer.monmouth.com!newsfeed.atl!news3.mia.POSTED!not-for-mail
From: "Wolf" <wolf@mrsoxx.com>
Newsgroups: comp.databases.oracle.misc
References: <386afcf3$0$222@nntp1.ba.best.com>
Subject: Re: DateTime in SQL
Lines: 15
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <yqqb4.6816$zp.101088@news3.mia>
Date: Sat, 1 Jan 2000 11:53:19 -0500
X-Trace: news3.mia 946746142 209.214.128.83 (Sat, 01 Jan 2000 12:02:22 EST)
NNTP-Posting-Date: Sat, 01 Jan 2000 12:02:22 EST

You need to use the quoted date format model as the second argument in the
to_date function.

select * from  <table> where <datefield> = to_date('12/28/99
19:00:00','MM/DD/YY HH24:MI:SS');

Bob Johnson <robertsj@best.com> wrote in message
news:386afcf3$0$222@nntp1.ba.best.com...
> 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
>
>