4

select... from... where R.WORK_YM = 201611

how to change R.WORK_YM to String value?

Dang Anh
  • 43
  • 1
  • 1
  • 6

3 Answers3

3

Try this:

select... from... where cast(R.WORK_YM as varchar(10))= '201611'
Ranjana Ghimire
  • 1,785
  • 1
  • 12
  • 20
3

Try this Query for SQL Server,

Use CONVERT function

select * from Table R where CONVERT(varchar(10), R.WORK_YM) = '201611'

OR

Use STR function

select * from Table R where STR(R.WORK_YM,10) = '201611'

OR

Use CAST function

select * from Table R where CAST(R.WORK_YM as varchar(10)) = '201611'

For MySQL,

Use CAST function

select * from Table R where CAST(R.WORK_YM as Char(10)) = '201611'

Use CONVERT function

select * from Table R where CONVERT(Char(10), R.WORK_YM) = '201611'
Kushan
  • 10,657
  • 4
  • 37
  • 41
  • I tried every query you posted but it's still not work and the error is: Error Code: -461, SQL State: 42846] DB2 SQL error: SQLCODE: -461, SQLSTATE: 42846, SQLERRMC: SYSIBM.INTEGER;SYSIBM.VARCHAR – Dang Anh Nov 03 '16 at 04:16
  • no worries , I got the answer from Ranjana Ghimire: where cast(R.WORK_YM as char(10))= '201611' Thank you! – Dang Anh Nov 03 '16 at 04:30
  • ohh you are using mysql. ok great – Kushan Nov 03 '16 at 04:32
0

for conversion in oracle use

to_char(201611)

https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions181.htm

Giuseppe
  • 36
  • 2