Answer the question
In order to leave comments, you need to log in
How to select "date time" rows in oracle db?
Good afternoon! There is a table like this:
ARTICLE DATE
104425 05.09.2014
105996 24.07.2014
105999 13.07.2014 3:00:00
106005 14.08.2014
106008 05.07.2014
Answer the question
In order to leave comments, you need to log in
docs.oracle.com/cd/B19306_01/server.102/b14200/fun...
select * from table
where extract(time from date) <> '00:00:00'
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question