Dang Anh Dang Anh - 1 year ago 144
MySQL Question

How to covert INT to VARCHAR in SQL condition

where R.WORK_YM = 201611

how to change R.WORK_YM to String value?

Answer Source

Try this:

select... from... where cast(R.WORK_YM as varchar(10))= '201611'
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download