lejo

lejo

  • 978
  • 384
  • 11.7k

year ,month ,f i am giving date 02-01-2022 to 25-02-2024 how two sday

Apr 4 2024 2:09 PM

if i am giving date

from date :02-02-2023

to date    :25-04-2024  

show completed year,balance months and days   

result will be 1 year   02-02-2023  -02-02-2024 

month  will be 2 months  02-02-2024 -  02-04-2024

days wiil be  23  days   02-04-2024-25-04-2024   

how to write sql query to get result will in  1 year,2 months and 23 days


Answers (1)