SQL Tutorial for Data Analysis 21: Conversion Functions
In this SQL tutorial we’re going to learn how to use the conversion functions.
Conversion functions, allow us to convert one type of value to another, for example convert string data type to integer, or date datatype to string, and so on.
Key concepts to remember -
There are main two differences between the CAST and CONVERT functions: (1) The CONVERT function has an optional STYLE argument (2) the CAST function is considered as an ANSI Standard SQL while the CONVERT function is not, CONVERT is actually a specific SQL Server implementation.
Course Examples -
https://ramkedem.com/en/sql-basics-ex...
ACDB Database -
https://ramkedem.com/en/acdb-sample-d...
Written SQL tutorials including exercises -
http://ramkedem.com/en/sql-server/
About Myself -
https://ramkedem.com/en/about/
My Linkedin Page -
/ ram-kedem-a5b4b33b
My Facebook Page -
/ ramkedemfeed
Platform Differences (comparing MySQL & Oracle) -
MySQL CAST() function - https://www.w3schools.com/sql/func_my...
Oracle
(1) In Oracle we're capable of concatenating two different types of values without converting them
(2) CAST() function - https://docs.oracle.com/javadb/10.8.3...
(3) In Oracle we mainly use the following conversion functions: TO_CHAR,TO_DATE,TO_NUMBER -
http://www.dba-oracle.com/t_oracle_co...
On this page of the site you can watch the video online SQL Tutorial for Data Analysis 21: Conversion Functions with a duration of hours minute second in good quality, which was uploaded by the user Ram Kedem 06 September 2020, share the link with friends and acquaintances, this video has already been watched 1,392 times on youtube and it was liked by 11 viewers. Enjoy your viewing!
