Hello
I have problem with datatype DATE. Column DAY is DATE and query:
select count(*)
from cash_report
where day = '2009-10-01'
gave result: 2. I know, I have 2 records.
but query:
select *
from cash_report
where day = '2009-10-01'
gave error:
Truncated incorrect numeric value: 2009-10-01. Code: 1292
Brighthouse other specific error: BH result type not convertible to MySQL type. Code: 1105
Unknown error. Code: 1105
query:
select per_id
from cash_report
where day = '2009-10-01'
gave:
101010
202020
I think problem is DATE or data on this column, but I don’t know why…. and a few days ago everything was OK. I didn’t change configuration of Infobright, all queries on this table was excellent. Other tables with DATE column is OK.
I tried use DATE_FORMAT() or CAST() function on day column to check data, but I can’t see results.
What can I check, where to find? Maybe column DAY got incorrect data… but I can’t check it?
Thanks
Slawek
