Can't exec sql: SELECT
a.program_id,
b.title_inshort,
(a.broadcast_date + '6 hours') as time,
(a.broadcast_date + '6 hours' + '1 days') as time_next,
(a.broadcast_date + '6 hours' + '-1 days') as time_preview,
(a.broadcast_date + '1 month') as next_month,
a.series_no,b.title,c.info_digest,c.mode_icons,c.url,sub_category
FROM broadcast_fix_info a
LEFT JOIN program_info b USING(program_id)
LEFT JOIN broadcast_base_info c ON a.program_id=c.program_id AND a.series_no=c.start_type
WHERE broadcast_date
between date('2013--') AND (date_trunc('day',date'2013--') + '1 days') ORDER BY broadcast_date
reason: ERROR: invalid input syntax for type date: "2013--"
行 13: between date('2013--') AND (date_trunc('day',date'2013-...
^
エンタ!959/番組表
