Thanks a lot Mr.Andras Belokosztolszki,

you solved my problem...I was thinking I can not retrieve the SQL query result in an Int variable :doze::crying:

Thanks alot Mr. Jeffrey,

your solution is the best.

My best wishes to you.

Deal All,

Thanks for all ur replies.

I found out the error cause, it is not an error in the query. I suddenly found some values in the column DayTransTime (Decimal(6,0)) that...

Dear Jeffrey,

My application needs to store the dates as Decimal for some requirement, and your opinion to convert the decimal into date is right, and I was trying to write...

Thanks for ur Comments and reply,

First: I have two columns; one for the 'DayTransDate' like (2008/08/09) which is stored in the Data base as a Decimal= 20080709, and the...