I have ECC table where I want to extract records between particular dates.
I wrote in where clause of query transform
ECCTbName.FDat >= ‘2008.01.01’ and ECCTbName.FDat <= ‘2008.01.31’
Job runs but no data retrieved.
Can any one Help me
Ram18 (BOB member since 2013-08-16)
Try to change your condition from
ECCTbName.FDat >= ‘2008.01.01’ and ECCTbName.FDat <= ‘2008.01.31’
To
To_Char(ECCTbName.FDat,‘YYYYMMDD’) >= ‘20080101’ and To_Char(ECCTbName.FDat,‘YYYYMMDD’) <= ‘20080131’
srinivaslikesit (BOB member since 2007-04-03)
Normally I use a date variable for this.
Johannes Vink 
(BOB member since 2012-03-20)