Pass Through Query Translation

[Kou Vang]

How do I translate this into a pass through query? I've been puzzled over
this for a day now?

SELECT STORET1_TSRFDACT.START_DATE
FROM STORET1_TSRFDACT
WHERE ((Year([start_Date])=2008));

I keep getting an error '"YEAR": 'Invalid Identifier'

Thanks.
Kou

 

[Bob Barrows]

How do I translate this into a pass through query? I've been puzzled
over this for a day now?

SELECT STORET1_TSRFDACT.START_DATE
FROM STORET1_TSRFDACT
WHERE ((Year([start_Date])=2008));

I keep getting an error '"YEAR": 'Invalid Identifier'

What is the database you're passing this through to?

 

[Jerry Whittle]

Year is not a valid function in the database that you are trying to use. You
need to find out what kind of database and what function you can use in it.
For example something like below should work with Oracle.

WHERE to_number(to_char([startdate],'YYYY')) = 2008 ;

or

WHERE to_char([startdate],'YYYY') = '2008' ;