Casting from Sage

[everreadyeddie]

Hi All

I am attempting to select by date from the Sage Accounts package using:

SELECT * FROM F_ECRITUREC WHERE cast(CBMODIFICATION AS char) = '2009-06-20'

but I get:

SQL error: [Simba][Simba ODBC Driver]
SELECT * FROM F_ECRITUREC WHERE cast(CBMODIFICATION AS<< ??? >> char) = '2009-06-20'

I'm assuming CBMODIFICATION is a date object on the database as it is in YYYY-MM-DD format.

Can anyone help me?
Many thanks.

[dagon]

there is no need to use cast you can compare 2 dates directly.

[everreadyeddie]

Ah, got it.

SELECT * FROM F_ECRITUREC WHERE CBMODIFICATION >= '2009-06-20'

Thanks.