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...
Sur cette page du site, vous pouvez voir la vidéo en ligne SQL Tutorial for Data Analysis 21: Conversion Functions durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Ram Kedem 06 septembre 2020, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 1,392 fois et il a aimé 11 téléspectateurs. Bon visionnage!
![[25 years of mobile sales experience🔥] An in-depth interview with a man who continues to sell hot...](https://image.4k-video.ru/id-video/h1xNZTMiNak)
