HANA SQL获取当前月的第一天

SELECT ADD_DAYS(CURRENT_DATE,-EXTRACT(DAY FROM CURRENT_DATE) + 1) FROM DUMMY; SELECT ADD_MONTHS(NEXT_DAY(LAST_DAY(CURRENT_DATE)),-1) FROM DUMMY;SELECT ADD_DAYS(LAST_DAY(ADD_MONTHS(CURRENT_DATE,-1)),1) FROM DUMMY;

方法有很多种，这里只列出了常用的几种。

找到了几个比较好的写法，请参考

Guys ,Few common HANA SQL logic I Know first day of month: ADD_DAYS(LAST_DAY(ADD_MONTHS(CURRENT_DATE,-1)),1)last day of month: LAST_DAY (CURRENT_DATE)first day of quarter: ADD_DAYS( ADD_MONTHS( CURRENT_DATE,(MOD( MONTH(CURRENT_DATE) -1, 3 )) * -1) ,DAYOFMONTH(CURRENT_DATE)* -1 + 1 )first day of year: ADD_DAYS(CURRENT_DATE, DAYOFYEAR (CURRENT_DATE)* -1 + 1)last day of Prior year:ADD_DAYS(CURRENT_DATE, DAYOFYEAR (CURRENT_DATE)* -1 )   direct Filter / Where clauseCurrent Month: to_char(TIME_DIMENSION.Column_DATE,'YYYYMM' ) = to_char(CURRENT_DATE,'YYYYMM' )Current Quarter: {fn Quarter(TIME_DIMENSION.Column_DATE)} = {fn QUARTER(CURRENT_DATE)}Current Year: {fn year(TIME_DIMENSION.Column_DATE)} = {fn year(CURRENT_DATE)}