Mysql Time Difference Function is used to find the time difference between any two dates.

Mysql Time Difference Function

     

Mysql Time Difference Function is used to find the time difference between any two dates.

Understand with Example

The Tutorial describe an example that helps you to understand 'Mysql Time Difference  Function'. In this example we use TimeDiff('Year1 Time1', 'Year2 Time2') query that return you the time difference between any two consecutive dates.

TimeDiff('Year1 Time1', 'Year2 Time2') : The Query performs the time difference between any consecutive dates.

 

 

Query to Time Difference Function

mysql> SELECT TIMEDIFF('2009:01:08 00:00:00', '2008:01:01 00:00:00.000001'); +---------------------------------------------------------------+ | TIMEDIFF('2009:01:08 00:00:00', '2008:01:01 00:00:00.000001') | +---------------------------------------------------------------+ | 8951:59:59.999999 | +- --------------------------------------------------------------+ 1 row in set (0.00 sec)

Related Tags for Mysql Time Difference Function:
sql,  mysql,  c,  date,  time,  function,  diff,  fun,  io,  dates,  sed,  find,  difference,  if,  unc,  to,  between,  e,  use,  im,  ce,  in,  m,  tween,  es,  func,  me,  s,  ee,  etw,  at,  any,  my,  is,  ime,  tw,  s,  s,  ren,  th,  fe,  fin,  nd,  on,  o

More Tutorials from this section

• SQL Date, SQL Date Examples
• SQL Date
• MySQL By Date
• MySQL By Week
• Mysql date API
• Mysql Date Arithmetic
• Mysql Date in between
• Mysql Date Default
• Mysql date equal
• Mysql date field
• Mysql Date Filter
• Mysql Date Format codes
• Mysql Date Format Convert
• Mysql Date Format
• Mysql Date from Date
• Mysql Date and Time
• Mysql Date Functions
• Mysql Date Index
• Mysql Date Input
• Mysql Date To Java Date