HQL Statement Cast usage

Cast as conversion function in HQL

Cast (A as B); A is the data to be converted, B is the target type (not the database type name, is the hibernate type name: such as the target type is varchar, must write a string)

Eg:select * FROM table where cast (field name to convert as String) <> ';//identify a data that requires a conversion field that is not empty

1. SELECT cast (' 2016-12-04′as date) converts string to date type
2. SELECT CAST (As String) converts the number to a string
3, SELECT CAST (' Ceshichangdu ' as char (3)) takes a specified length of character

HQL Statement Cast usage