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: Richard McDowell <mcdowell_richard_at_hotmail.com>
Date: Sun, 2 Jan 2000 11:27:46 +0100
Message-ID: <84n93p$sbab$1@fu-berlin.de>


Bob Johnson <robertsj_at_best.com> schrieb in im Newsbeitrag: 386afcf3$0$222_at_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')

You have to specify format for date!
Take a look at the definition of "to_date" statement.

/richard

/..developing with www.visual-engine.com and /..designing things, as never before. Received on Sun Jan 02 2000 - 04:27:46 CST

Original text of this message

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