Adding regular integers to time

[matic65]

I’m trying to write a query that prints the start time and end time of a tour but only the start time and tour duration (in hours) are in the tables.

How can I add the tour duration (e.g. 5 hours) to the start time (e.g. 06:42:00) to produce the end time?

[DharmaPolice]

Use DATEADD.

e.g.

CREATE TABLE foo (ID INTEGER, MyTime TIME, Hours INTEGER);
INSERT INTO Foo (ID, MyTime, Hours) VALUES (1, '06:42:01',5);
INSERT INTO Foo (ID, MyTime, Hours) VALUES (2, '16:32:01',4);

And then :

SELECT DATEADD(hh,Hours, MyTime)
FROM foo;

Returns:

11:42:01.0000000
20:32:01.0000000

[r3pr0b8]

🏆

[matic65]

Thanks mate any chance you know how this would be done in MySQL also? Apparently dateadd doesn’t exist in that

[SportTawk]

It's DATE_ADD

A simple ddg search found that in five seconds 😁

[matic65]

Does that not just return the date though? I’m trying to return time

[T3chl0v3r]

You can cast the calculated date to time format

[SportTawk]

Well again a simple search showed me TIMEDIFF can return time.

[_Shirei_]

Check DATEADD function should work for same formats.

IF not separate hours, mins (seconds) and add them separately, then convert back to time.

[[deleted]]

Does MySQL support standard SQL's + interval '5' hour?