LogoMakerCa-1587613265609_edited.jpg
  • Home

  • About

  • Video Tutorial

    • Microsoft Power BI
    • Alteryx
    • Tableau
    • MicroStrategy
    • HP LoadRunner
    • HP UFT
  • Text Tutorial

    • Microsoft Excel
    • SQL
  • Downloads

    • Microsoft Power BI
  • Reach Us

  • More

    Use tab to navigate through the menu items.
    • Udemy
    • Facebook
    • Twitter
    • YouTube
    • Linkedin

    SQL - WORKING WITH DATES

    MYSQL FORMAT | SQL SERVER | EXAMPLE | QUERY | OUTPUT

     

    SQL follows different approaches for DATE Format in MYSQL & SQL SERVER

    MYSQL FORMAT

    220.png

    SQLSERVER

    221.png

    EXAMPLE 

    Let’s consider a DEMO Database with Table Individual

    222.png

    Figure 50.1. Individual TABLE

    QUERY

    223.png

    OUTPUT

     
     
    224.png
     
     
    Previous
    Next
    Back to Top

    Want More SQL Deep Dives

    1. SQL Introduction

    2. Database Overview

    3. Creating a Database

    4. Dropping a Database

    5. Table Fundamentals

    6. Table Types

    7. Datatypes in SQL

    8. DDL, DML, TCL & DCL

    9. Null & Not Null Values

    10. Creating Tables

    11. SQL - Constraints

    12. SQL - Index 

    13. SQL Inserting Data

    14. SQL Identity Columns

    15. Selecting Data

    16. Using Distinct

    17. SQL in NOT IN

    18. Using Top Clause

    19. Where Clause

    20. Group By

    21. Order By

    22. Having

    23. Exists

    24. Offset

    25. SQL - Operators

    26. Between

    27. Update

    28. Delete

    29. SQL - Aggregate Functions

    30. SQL - Introductions to Joins

    31. Table Alias

    32. SQL - Inner Join

    33. SQL - Left Join

    34. SQL - Right Join

    35. Full Join

    36. Self Join

    37. SQL Union

    38. Pivot

    39. Alter Command

    40. Limit Clause

    41. Truncate

    42. Drop

    43. Table Backup

    44. SQL - Normalization

    45. Subquery

    46. SQL - Views & Materialized Views

    47. Case Statement

    48. SQL Transactions

    49. SQL - Scaler Functions

    50. Working with Dates

    51. Grant revoke

    52. SQL - Performance Tunning

    53. Stored Procedure Basics

    54. Stuff function

    55. Keyword

    56. SQL - Miscellaneous

    ©2020 by Pavan Lalwani.