Kesavan Muthuvel's Personal Home Page

Index| Bookmarks| I'm supporting| More info? (About me!)| Royal Thunderbird!| Maemo N900| Nexus & Pixel (Android + more )| KODI [aka] XBMC | My Public Key (GPG) | My Sign| Travel Snaps| Blog

Thanks to..| Open Materials| interview qns| scripts to look| eBooks Collection| Web Dev tips

Looking for a girl| A day - a cartoon| Shameless self promo| Goodbye GMail

தமிழ்: Type தமிழ் | Sorry, pythagoras! | Thirukkural - #PIEM

Tools: What's your IP| Resize your image| Dark status from Tor| Random token gen| RegEx me!

Double trouble: Wed Lock - 2014| Wedlock Invitation| Thulasi Kesavan| Kundavai Kesavan

Scripts I like

CREATE FUNCTION getDateDifferenceString(date1 DATE, date2 DATE) 
RETURNS VARCHAR(30)  
RETURN CONCAT(    
@years := TIMESTAMPDIFF(YEAR, date1, date2),  
    IF (@years = 1, ' year, ', ' years, '),    
@months := TIMESTAMPDIFF(MONTH, DATE_ADD(date1, INTERVAL @years YEAR), date2),  
    IF (@months = 1, ' month, ', ' months, '),    
@days := TIMESTAMPDIFF(DAY, DATE_ADD(date1, INTERVAL @years * 12 + @months MONTH), date2),  
    IF (@days = 1, ' day', ' days')  
);

/* USAGE 
mysql> SELECT getDateDifferenceString('2006-03-01',NOW()) MyExperience;
+----------------------------+
| MyExperience               |
+----------------------------+
| 5 years, 5 months, 23 days |
+----------------------------+
1 row in set, 1 warning (0.00 sec)
*/


Return to Kesavan Muthuvel's home page. Please send comments on these web pages to hi@kesavan.info (or)  Feedback here CopyLeft (Ͻ) 2008 - 2023 Kesavan Muthuvel More on CopyLeft