Skip to Content
0
Jan 12, 2012 at 06:50 PM

Querying VIRSA_CC_MITUSER table using a particluar date

25 Views

Hi Experts,

I need to find the users Mitigated on a Particluar date and in a month for Audit Purpose.

As there is no Change Document to check this in RAR 5.3, i am forced to turn to Ccdebugger.

While i have used the SQL query for simple executions, i am faced with a problem VIRSA_CC_MITUSER table using date format.

When i use query

select * from VIRSA_CC_MITUSER where validfrom=('2011-12-02')

i get the error

"ErrorThe SQL statement "SELECT * FROM "VIRSA_CC_MITUSER" WHERE "VALIDFROM" = '2012-01-12'" contains the semantics error[s]: - 1:38 - type check error: the left hand side >>"VALIDFROM"<< (DATE) and the right hand side >>'2012-01-12'<< (CHAR) of a comparison operator are not comparable "

Help is appreciated. I know this query would sound silly to you experts, but i am struggling with this for the past few days and time is running out.

With Regards,

Ganesh.S