Oracle does not display INT type, just define it as number, and the forced type conversion function is similar. The conversion to date type is TO_DATE ().

The number to be converted is TO_NUM (), the character to be converted is TO_CHAR (), the content to be converted is in brackets, and the date type should pay attention to the format mask.

Extended data:

Matters needing attention

CAST()？ And CONVERT ()? Function can be used to get one type of value and produce another type of value.

This type? Can be one of the following values. One:

binary system

Character [(N)]

date

Date time

decimal

Signed it? [integer]

time

Not signed? [integer]

So you can also use CAST to solve this problem:

Choice? server_id？ From where? cardserver？ Where is it? game_id？ =? 1? Order? By who? CAST(server_id？ As? Signature)? desc？ Limit? 10

You can also use CONVERT to solve this problem:

Choice? server_id？ From where? cardserver？ Where is it? game_id？ =? 1? Order? By who? CONVERT(server_id, signed)? desc？ Limit? 10