syntax error when cast in EXTRACT

Question

I just try this and I got a syntax error with tdate (it a DATE type)

select *
from treatment
where  EXTRACT(month FROM cast (date as TIMESTAMP) tdate) = EXTRACT(month FROM cast (date as TIMESTAMP) current_date)

is anyone can help me out..?? thanks!!!!

tittaenälg · Accepted Answer · 2014-11-18 21:41:31Z

1

I do not think you need to bother casting either field since you should be able to extract the month directly from both. I would try:

select * 
from treatment 
where extract(month from tdate) = extract(month from current_date)

answered Nov 18, 2014 at 21:41

tittaenälg

3862 silver badges5 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

sgeddes · Accepted Answer · 2014-11-18 21:23:50Z

1

Is this what you're looking for instead:

select *
from treatment
where EXTRACT(month FROM cast (tdate as TIMESTAMP)) = 
      EXTRACT(month FROM cast (current_date as TIMESTAMP))

It should be cast(field as type) where you have cast(date as type).

answered Nov 18, 2014 at 21:23

sgeddes

62.9k7 gold badges68 silver badges85 bronze badges