syntax to convert date to interger in msssql code example Example: mysql parse int SELECT CAST(PROD_CODE AS INT) FROM PRODUCT