June 7th, 2011, 07:05 AM
|
 |
Contributing User
|
|
|
|
Quote: | Originally Posted by Headworth I am using oracle 10g i have a table on my computer that i made for a friend when i load it on their computer the select statements say no data found
if i use select * from table name all the data will show
but if a column name select * from table name where duty_date = '05-JAN-11'
no data found
Please can you help |
Always compare DATES to DATES:
Code:
SELECT *
FROM table_name
WHERE duty_date = TO_DATE('05-JAN-11','DD-Mon-YY')
__________________
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Select statement
Linear Mode
