Z
Z
zotovby2014-05-22 17:00:56
Oracle
zotovby, 2014-05-22 17:00:56

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

How can I select records that have time?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
S
svd71, 2014-05-22
@zotovby

docs.oracle.com/cd/B19306_01/server.102/b14200/fun...

select * from table
where extract(time from date) <> '00:00:00'

Z
zotovby, 2014-05-22
@zotovby

can it be like this
select * from your_table where trunc(date) != date

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question