最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

sql - Dbeaver says column 'MONTH' cannot be found, however I am clearing not referencing a column for 'M

programmeradmin1浏览0评论

sql script

I don't understand why the following script and screenshot above is showing the 'MONTH' column as not being recognized. This is clearly not a table column and it is an input for the function.

--- Check for next months accounting day
SELECT * 
FROM CI_MISSION_CONTROL_DM_PROD_DB.MASTER.MDM_CALENDAR_V1_VW 
WHERE DAY_DATE BETWEEN DATEADD(MONTH, 1, DATE_TRUNC('MONTH', CURRENT_DATE()))
              AND DATEADD(DAY, -1, DATEADD(MONTH, 2, DATE_TRUNC('MONTH', CURRENT_DATE())))
AND WORKDAY_DESCRIPTION = 'Accounting Day'
AND WORKDAY_NUMBER = 8;

与本文相关的文章

发布评论

评论列表(0)

  1. 暂无评论