Pass Through Query Translation

  • Thread starter Thread starter Kou Vang
  • Start date Start date
K

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
 
Kou said:
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'
Click to expand...
What is the database you're passing this through to?
 
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' ;
 
Back
Top