Browse: Home / to_date

to_date

How to search by date in Oracle

By on July 19, 2014

The to_date function we talked earlier make a come back. The wrong way to do it is : SELECT field 1, field2, date_and_time, FROM table1 WHERE date_and_time = ’12-04-27′ you end up comparing string in that case to work you need to do the following: SELECT field 1, field2, date_and_time, FROM table1 WHERE date_and_time = […]

Posted in , | Tagged , , , | Leave a response

ORACLE Date won’t work with greater or lesser than operator

By on July 12, 2014

I was having problem making one of my SQL query work in ORACLE until I realize that I got the check on the date wrong. It seem that Oracle didn’t interpreted my query has I expected when handling a date with a greater or lesser than operator (< or >). So this won’t work : […]

Posted in | Tagged , , , | Leave a response