Brungard
Monday, 26 August 2013
Difference between two datetime entries
Difference between two datetime entries
SELECT ETA,STA FROM `Schedule` WHERE `Num`="5567";
2013-08-26 18:37:00 2013-08-26 18:30:00
SELECT DATEDIFF(ETA,STA) FROM `Schedule` WHERE `Num`="5567";
0
Why the result is 0 instead of 7 (i.e. minutes)?
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment