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....
I have below code and trying to convert to sql any help would be great?
TRUNC ( ( ADD_MONTHS(A.SERVICE_DT - 1 , 7) ), 'MONTH')
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?
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?