How to calculate the difference between two time values?
Answer / Himanshu Vishnoi
In MySQL, you can calculate the difference between two time values using TIMESTAMPDIFF function: SELECT TIMESTAMPDIFF(unit, start_time, end_time); where unit is the type of time interval (YEAR, MONTH, DAY, HOUR, MINUTE, or SECOND).
| Is This Answer Correct ? | 0 Yes | 0 No |
What language is mysql written in?
what is the default port for mysql server? : Mysql dba
List some mysql advantages and disadvantages?
Where is the mysql data directory?
What does blob mean in mysql?
How to display nth highest salary from a table in a mysql query?
How do we delete a row in a table?
How do I change global variables in mysql?
What is pragma serially_reusable and why is it used?
How to get the number of rows selected or affected by a sql statement?
what is mysql optimization in brief?
How can I insert images into a Mysql database?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)