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.