need help with dates in teradata

[Shrutisinha]

Please somebody could help me with dates .. its giving me error thanks
select c.bill_dt from
emp c,dept b
where c.ban=b.ban
and c.BILLED_DT Between (add_month(b.STATUS_EFF_DT,-1)
And b.STATUS_EFF_DT

[debasisdas]

for between operator u need 2 dates
where is the second date.

[Shrutisinha]

well STATUS_EFF_DT is a date record .. so that not the problem.. thanks

[debasisdas]

Try manipulating with some parenthesis in the later part

I hope it will solve your problem

[r035198x]

Please somebody could help me with dates .. its giving me error thanks
select c.bill_dt from
emp c,dept b
where c.ban=b.ban
and c.BILLED_DT Between (add_month(b.STATUS_EFF_DT,-1)
And b.STATUS_EFF_DT

Looks like you are missing a closing bracket.

[Shrutisinha]

not working still :(

[debasisdas]

I have tried similar code in Oracle its working fine

sample code
==============

select * from emp e ,dept d where e.deptno=d.deptno and
hiredate between (add_months(e.hiredate,-1)) And e.hiredate
 

hope that helps you.

[r035198x]

not working still :(

What do you have now?

[frozenmist]

Hi,
May I know what is the error you are getting?
Also ,Is it
select c.bill_dt or

Select c.billed_dt
??

Cheers

[r035198x]

Hi,
May I know what is the error you are getting?
Also ,Is it
select c.bill_dt or

Select c.billed_dt
??

Cheers

Good pick frozen. That must be the problem.