Casting
Posted: Sun Jun 21, 2009 7:59 am
Hi All
I am attempting to select by date from the Sage Accounts package using:
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.
I am attempting to select by date from the Sage Accounts package using:
Code: Select all
SELECT * FROM F_ECRITUREC WHERE cast(CBMODIFICATION AS char) = '2009-06-20'
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.