ODBC Query working with DATES.

[Pinball4ever]

Hi all,

I've been working with a query with ODBC (32-bits) connecting through a DB2/AS400 database.

I have certain records of the database, but now i want to check the mutation date (mutmutdat) with the current date.
(with ODBC-SQL).

However my query WHERE MUTMUTDAT = CURDATE() isn't working since the output of MUTMUTDAT = yyyymmdd

CURRENTDATE or CURDATE is just showing '7/10/2005'.
Also the CONVERT command doesn't work.

Who can help me out ?? Or having tips to handle date's compared with the system date.

Thanks all !

Best Regards,
Alex

 

[plevey]

You need to convert MUTMUTDAT from DECIMAL to a DATE type.
Try something like

WHERE
CAST(CAST(CONCAT(CAST( MUTMUTDAT AS CHAR(8) ) , '000000') AS TIMESTAMP) AS DATE) = CURDATE()


If fishing was easy it would be called catching