ERROR: syntax error while executing query in PostgreSQL

Question

I am attempting a SQL query and getting this error:

ERROR: syntax error at or near "rental_date"
LINE 4: select I.store_id,EXTRACT(MONTH FROM TIMESTAMP rental_date) ...

This is my code:

select 
    store_id, Month_Name, max(RentOrder) as maximum_order 
from 
    (select 
         I.store_id, EXTRACT(MONTH FROM TIMESTAMP rental_date) as Month_Name,
         count(rental_id) as RentOrder 
     from 
         Rental R 
     inner join 
         Inventory I on R.inventory_id = I.inventory_id 
     group by 
         I.store_id, EXTRACT(MONTH FROM TIMESTAMP rental_date) ) as T 
group by 
    store_id, Month_Name

I have checked the names of the variables thoroughly matching my database.

However, it is still throwing the syntax issue. Assistance would be appreciated to solve this!

Zaynul Abadin Tuhin · Accepted Answer · 2018-08-05 09:01:27Z

1

i just remove timestam from your query A and rest of the things are fine

 select 
        store_id, Month_Name, max(RentOrder) as maximum_order 
    from 
        (select 
             I.store_id, EXTRACT(MONTH FROM rental_date) as Month_Name,
             count(rental_id) as RentOrder 
         from 
             Rental R 
         inner join 
             Inventory I on R.inventory_id = I.inventory_id 
         group by 
             I.store_id, EXTRACT(MONTH FROM rental_date) ) as T 
    group by 
        store_id, Month_Name

answered Aug 5, 2018 at 9:01

Zaynul Abadin Tuhin

32.1k6 gold badges37 silver badges66 bronze badges

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

Comments

sticky bit · Accepted Answer · 2018-08-05 06:13:27Z

0

I assume rental_date already is a timestamp. Remove the TIMESTAMP in the EXTRACT() calls.

...
EXTRACT(MONTH FROM rental_date)
...

answered Aug 5, 2018 at 6:13

sticky bit

37.7k12 gold badges34 silver badges46 bronze badges

Collectives™ on Stack Overflow

ERROR: syntax error while executing query in PostgreSQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related