how to calculate the difference between two dates? : Sql dba



how to calculate the difference between two dates? : Sql dba..

Answer / Sandeep Bhatnagar

To calculate the difference between two dates in MySQL, you can use the DATEDIFF() function. Example: SELECT DATEDIFF('2023-05-15', '2023-04-15'); will return 30.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is the syntax to add a record to a table?

1 Answers  


What is nvl function?

4 Answers   Cap Gemini,


What is normalization ?

9 Answers   BirlaSoft, CTS, HCL,


which will fire first ? Trigger or Constraint

24 Answers   i2, IBM,


how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1 Answers  


Does oracle use sql?

1 Answers  


What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

1 Answers  


while loading data into database how can u skip header and footer records in sql*loader

1 Answers   Oracle,


Can we connect to postgresql using sql developer?

1 Answers  


What is trigger in sql and its types?

1 Answers  


What is NOCOPY?

6 Answers   DELL,


Why is sharding used?

1 Answers  


Categories