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...
Nesta página do site você pode assistir ao vídeo on-line SQL Tutorial for Data Analysis 21: Conversion Functions duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Ram Kedem 06 Setembro 2020, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 1,392 vezes e gostou 11 espectadores. Boa visualização!
