syntax error near unexpected token `TO

syntax error near unexpected token `TO_CHAR(L'

Thread view:

aemi - 02 Mar 2007 05:14 GMT

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'

Reply to this Message

Dimitri Kurashvili - 02 Mar 2007 05:43 GMT

> I fired this query
>
[quoted text clipped - 5 lines]
>
> syntax error near unexpected token `TO_CHAR(L'

if this is Oracle, then everything seems ok.

Reply to this Message

Daniel Pitts - 02 Mar 2007 06:31 GMT

> I fired this query
>
[quoted text clipped - 5 lines]
>
> syntax error near unexpected token `TO_CHAR(L'

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

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...