Re: DateTime in SQL

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_at_best.com> wrote in message news: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')
> But, this doesn't work. How do I do this? Thanks, Bob
>
>
Received on Sat Jan 01 2000 - 10:53:19 CST