现有一个需求,将用户前台输入的if else语句转为postgrep语句
if else 已经有同事在转了,但是里面的函数需要我来转,如下:
"if(date2num(%test_date%,week,'zh')>=1){return date2num(%test_date%,month);}else{date2num(str2date(%test_date%,'yyyy-MM-DD'),month);}"
也就是将
date2num(%test_date%,week,'zh')
date2num(%test_date%,month)
date2num(str2date(%test_date%,'yyyy-MM-DD'),month)
分别转成
cast(to_char(cast('inputdate' as date),'ww') as int2)
cast(to_char(cast('inputdate' as date),'mm') as int2)
cast(to_char(cast(to_char(cast('inputstr' as date),'dd.MM.yyyy')),'mm') as int2)
参数也要根据前台传的字符串去替换