我有以下表在我的Postgres数据库:
MY_TABLE
date_col |id_col
----------+---------
2017-12-28|892800126
2018-01-03|892814475
2018-01-03|892803143
2018-01-03|892803710
2018-01-03|892813971
2018-01-03|892803143
2018-01-03|892804791
我需要创建一个新的列与年,月和日在每一个从'日期'列。我怎么做呢?我一直在这样尝试:
select date_col, id_col
extract(year from date_col) as ano,
extract(month from id_col) as mes
from MY_TABLE;
我已经尝试了很多方法,但是我收到了消息SQL错误[42601]:Error:在"提取"处或附近有语法错误。位置:28">
谁来帮帮我。
请试试
select date_col,id_col,
extract (year from date_col) as m_year,
extract (month from date_col) as m_month ,
extract (day from date_col) as m_day
from MY_TABLE;