SQL - WORKING WITH DATES

 

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

MYSQL FORMAT

SQLSERVER

EXAMPLE 

Let’s consider a DEMO Database with Table Individual

Figure 50.1. Individual TABLE

QUERY

OUTPUT

 
 
 
 

©2020 by Pavan Lalwani. 

  • Udemy
  • Facebook
  • Twitter
  • YouTube
  • Linkedin