on 01-28-2021 5:39 PM
Hello,
I'm trying to get report from last business day. It works like this:
select sysdate-1 from dual
but as you can see it will not work for Monday.
I'm not sure why but daypart doesnt work on Free-hand SQL query.
Select ( case when datepart(dw, sysdate) = '7' then sysdate - 3 ELSE sysdate - 1 END ) as Nedd FROM dual
Could you pleas help me? Do you know which sql functions are supported by FHSQL?
Thank you,
Andi
User | Count |
---|---|
74 | |
8 | |
8 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.