syntax error near unexpected token `TO_CHAR(L'

[aemi]

I fired this query

SELECT TO_CHAR(LST_UPDT_TS, 'MMDDYY'),COUNT(ROWID) FROM
SP_ADDLPAY_DATA WHERE LST_UPDT_TS>TO_DATE('01012007','MMDDYY') GROUP
BY TO_CHAR(LST_UPDT_TS,'MMDDYY');

n I got this error why?

syntax error near unexpected token `TO_CHAR(L'

 

[Dimitri Kurashvili]

I fired this query

SELECT TO_CHAR(LST_UPDT_TS, 'MMDDYY'),COUNT(ROWID) FROM
SP_ADDLPAY_DATA WHERE LST_UPDT_TS>TO_DATE('01012007','MMDDYY') GROUP
BY TO_CHAR(LST_UPDT_TS,'MMDDYY');

n I got this error why?

syntax error near unexpected token `TO_CHAR(L'

if this is Oracle, then everything seems ok.

 

[Daniel Pitts]

I fired this query

SELECT TO_CHAR(LST_UPDT_TS, 'MMDDYY'),COUNT(ROWID) FROM
SP_ADDLPAY_DATA WHERE LST_UPDT_TS>TO_DATE('01012007','MMDDYY') GROUP
BY TO_CHAR(LST_UPDT_TS,'MMDDYY');

n I got this error why?

syntax error near unexpected token `TO_CHAR(L'

Possibly because this is a Java newsgroup, and that appears to be an
SQL statement.