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...
In questa pagina del sito puoi guardare il video online SQL Tutorial for Data Analysis 21: Conversion Functions della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Ram Kedem 06 settembre 2020, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 1,392 volte e gli è piaciuto 11 spettatori. Buona visione!
