ORACLE Date comparison issue - confused

Asked Sep 10 '13 at 04:24

Active Sep 10 '13 at 04:30

Viewed 102 times

I have the table that has a record with the value 23-JUL-13 for contact_date (Date type).

I tried to run this query:

select * from mytable
 where contact_date >= to_date('25-JUL-2012', 'dd-MON-yyyy')

I was expecting the above record to be returned.

Anything wrong here? Confused!

asked Sep 10 '13 at 04:24

Kevin Rave

6

Can you confirm if the date in your table is indeed 23-jul-2013. It could be 23-jul-1913 as well. – Noel Sep 10 '13 at 04:35
I just see the date as `23-JUL-13`. Is there a way to see the full date? – Kevin Rave Sep 10 '13 at 04:40
Works for me: http://sqlfiddle.com/#!4/d3721 – Nir Alfasi Sep 10 '13 at 04:40
`select to_char(contact_date, 'dd-mm-yyyy') mydate from mytable` – Nir Alfasi Sep 10 '13 at 04:41
2

@KevinRave, Use `select to_char(contact_date,'dd-mon-yyyy') from mytable`. – Noel Sep 10 '13 at 04:42
@alfasin, .. Lol! I think you are right. I see `23-07-0013` with to_char. – Kevin Rave Sep 10 '13 at 04:43
1

@KevinRave a good catch by Ramblin' Man (I don't deserve the credit ;) ) – Nir Alfasi Sep 10 '13 at 04:44
Well, the credit goes to @Ramblin' Man – Kevin Rave Sep 10 '13 at 04:44
@Ramblin' Man. Please post this as an answer for me to accept. – Kevin Rave Sep 10 '13 at 04:47

0 Answers0