Data Type Conversion

See the following topics for help on type conversion:

CAST Function
EXTRACT Function
Datetime Conversions for your chosen platform
Numeric Conversions for your chosen platform

Most platforms allow implicit conversion from one data type to another. Here’s an example in Oracle:

SELECT * FROM upfall WHERE id = '1';

It’s often better to use explicit type conversion so that you know for sure which value is getting converted and how.

Get SQL Pocket Guide, 3rd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.