:: double-colon type conversion AlaSQL supports :: operator: alasql('SELECT '10/12/2013'::DATE'); To cast types to Number you can use one of three forms: SELECT CAST(a AS NUMBER), FORMAT(NUMBER,a), a::NUMBER