Thanks but no, this is not SQL function Trun(Ad_month) is Oracle I have tried no of times to convert but its a bit Tricky to convert it to SQL....
Hi, I have below code and trying to convert to sql any help would be great? Thanks,. P. TRUNC ( ( ADD_MONTHS(A.SERVICE_DT - 1 , 7) ), 'MONTH')
Hi , I have below conversion from Oracle to SQL can you please chk and let me know if i did the conversion correct? Thanks! It does not look...
Thanks for tips but this is Oracle, I got tips form zargon and it works just had it in a wrong place within Query. Thanks you all.
Yeas it works I had the code in WHERE Clause which didn't work, not sure why it wont work in WHERE clause?
I did use your substring but still get 10 char? not YYYY.
Its not working I still get the YYYY-MM-DD? [ATTACH]
Thanks for tip! These were written by some one else and I am trying to convert them to SQL, I had the same question but person is not here anymore..
I have below date that want to convert to SQL but not working?? Not sure how to formulate this? FFDT=TO_CHAR(TO_DATE('2016-11-02', 'YYYY-MM-DD'),...