Home » SQL & PL/SQL » SQL & PL/SQL » Compare times
Compare times [message #38322] Wed, 10 April 2002 11:17 Go to next message
John Dunn
Messages: 3
Registered: April 2002
Junior Member
I am having problems selecting rows based upon the date and the time. I want to retrieve rows where , for example the date and time are greater than
03/03/2002 15:00

What syntax do I need?

Report message to a moderator

Re: Compare times [message #38325 is a reply to message #38322] Wed, 10 April 2002 13:13 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
 
select *
  from t
 where thedatecolumn > to_date('03/03/2002 15:00', 'mm/dd/yyyy hh24:mi');

Report message to a moderator

Previous Topic: how to
Next Topic: three maximum salary from each department?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 20:38:45 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.