Conversion Functions converts a value from one data type to another data type.
SQL Conversion and format functions
| Oracle | ||
| 1 | CAST | Convert one built-in data type into another |
| 2 | TO_CHAR for Datetime | Convert datetime to string |
| 3 | TO_DATE | Convert string to datetime |
| 4 | TRANSLATE | One-to-one single-character substitution |
| 5 | UNISTR | Convert Unicode code points to characters |
No comments:
Post a Comment