SQL SERVER语句如下:
SELECT *
FROM Personcard
WHERE CONVERT(varbinary(3), CONVERT(bigint, cardid))=CONVERT(varbinary(3), CONVERT(bigint, '"+ID+"'))
如何转为ORACLE。。
SELECT *
FROM Personcard
WHERE CONVERT(varbinary(3), CONVERT(bigint, cardid))=CONVERT(varbinary(3), CONVERT(bigint, '"+ID+"'))
如何转为ORACLE。。
oracle 中对应的有 to_data(timeString,formatType)
to_char()
SELECT *
FROM Personcard
WHERE CAST(CAST(cardid as number) as raw[])=CAST(CONVERT('"+ID+"' as number) as raw[])