28-Conversion Functions in SQL | Types of SQL Functions| CAST VS CONVERT | STR_TO_DATE | DATE_FORMAT

Поділитися
Вставка
  • Опубліковано 6 чер 2023
  • Are you new to SQL and looking to learn the basics quickly? Look no further! This tutorial is designed for beginners and will teach you the fundamentals of SQL .
    So what are you waiting for? Grab your coffee and let's get started!
    Complete SQL Tutorial Playlist- • SQL / MySQL Tutorial
    📚 SQL Practice Questions -
    codeera.netlify.app/sql-pract...
    🔶Create Employee Table
    codeera.netlify.app/wp-conten...
    🔶Insert Data into Employee Table
    codeera.netlify.app/wp-conten...
    Connect with us on different platforms
    ✅ Visit Our Website: codeera.netlify.app/
    ✅ Subscribe us on UA-cam: / @codeera2020
    ✅ Follow us on Instagram: / codeera_
    ✅ Follow us on Telegram: t.me/joingroupCodeEra
    📌27-Date & Time Functions in SQL| DATE_FORMAT(), DATE_ADD()...
    • 27-Date & Time Functio...
    📌-26-Numeric Functions in SQL | ABS(),MOD(),SQRT(),CEIL(),POWER()
    • 26-Numeric Functions i...
    📌25-String Functions in SQL
    • 25-String Functions in...
    📌24-Difference Between WHERE and HAVING CLAUSE in SQL
    • 24-Difference Between ...
    📌23-HAVING CLAUSE in SQL
    • 23-HAVING CLAUSE in SQ...
    📌22 -GROUP BY Clause in SQL
    • 22 -GROUP BY Clause in...
    📌21-Aggregate Functions in SQL | SUM | COUNT | AVG | MAX | MIN
    • 21-Aggregate Functions...
    📌20 -TOP Clause in SQL | FETCH FIRST Clause
    • 20 -TOP Clause in SQL ...
    📌19- LIMIT and OFFSET in SQL
    • 19- LIMIT and OFFSET i...
    📌18- ORDER BY Clause in SQL
    • 18- ORDER BY Clause in...
    ⭐Part 1:Top 9 SQL queries for interview -
    • Top 9 SQL queries for ...
    ⭐Part 2:Top 9 SQL queries for interview -
    • PART 2 : Top 9 SQL que...
    ⭐Top SQL Interview Question
    • Top SQL Interview Ques...
    ⭐Interview SQL Query On Joins
    • Interview SQL Query On...
    ⭐DBMS vs RDBMS
    • DBMS vs RDBMS | What i...
    ⭐SQL Query To Swap Value Of Male and Female In Single Statement
    • SQL Query To Swap Valu...
    string functions in sql
    string functions in sql
    string functions in sql in english
    string functions in mysql
    mysql string functions
    string functions in mysql in hindi
    #sql
    #sqlcourse
    #sqlforbeginners
    #string
    #strings
    #stringfunctions
    #datamanagement
    #database
    #sqltraining
    #sqltutorial
    #dataanalytics
    #dataanalysis
    #learnsql
    #sqlqueries
    #sqlprogramming
    #onlinelearning
    #techskills
    #elearning
    #onlinetraining
    #programming
    #sql
    #having
    #sqlhavingclause
    #groupbyclause
    #sqlgroupbyclause
    #sqlselectcommand
    #LearnCoding
    #coding
    #careerdevelopment
    #beginners
    #MySQL
    #databasemanagement
    #DBMS
    #techtutorials
    #sqlforbeginners
    #sqltutorial
    #sqlcourse
    #sqltraining
    #simplilearn
    #sqlintroduction
    #sqlfullcourse
    #oracledatabase
    #oracle
    #oraclesql
    #ask4help
    #learncoding
    #clause
    #sqlserver
    #top
    #sqlqueries
    #dateandtimefunctionsinsql
    #datefunctionsinsql
    #datefunctionsinsqlserver
    #GETDATE
    #DATEADD
    #DATEDIFF
    #DATENAME
    #datefunctions
    #DatefunctionsinSQLserver
    sql data types
    GETDATE
    DATEADD
    DATEDIFF
    DATENAME
    date functions
    Date functions in SQL server
    SQL Server tutorial
    ISDATE
    DATEPART
    CURRENT_TIMESTAMP
    DAY
    MONTH
    YEAR
    datename function in sql
    datename sql

КОМЕНТАРІ • 11

  • @passportbro904
    @passportbro904 14 годин тому

    I think for the cast one its better to show the actual decimal point for a better example. ill help you. SELECT CAST(10 AS DECIMAL(5, 2)) AS decimal_value; result = decimal_value

  • @kapilrathore3649

    thanks for content

  • @manishverma1025

    Very nice explanation

  • @Cake-bz5bf
    @Cake-bz5bf Рік тому +2

    Hello mam how you doing, just wanted to say pls make a detailed video on nested/subquery of sql as i have been always confused in that. Pls make a video about that from basic to advance.😊

  • @ranaprathap8292
    @ranaprathap8292 Рік тому

    Please explain the any testing side

  • @G.Rajini888

    Mam lexical functions ante entii quickly reply

  • @vineelsai111

    SELECT STR_TO_DATE('04 JUNE 2023