Archive
Age calculation in mysql Select query
Following is the way to calculate age based on date in mysql select query
SELECT name, birth, CURDATE(),TIMESTAMPDIFF(YEAR,birth,CURDATE()) AS ageFROM TableName;+----------+------------+------------+------+ | name | birth | CURDATE() | age | +----------+------------+------------+------+ | Fluffy | 1993-02-04 | 2003-08-19 | 10 | | Claws | 1994-03-17 | 2003-08-19 | 9 | | Buffy | 1989-05-13 | 2003-08-19 | 14 | | Fang | 1990-08-27 | 2003-08-19 | 12 | | Bowser | 1989-08-31 | 2003-08-19 | 13 | | Chirpy | 1998-09-11 | 2003-08-19 | 4 | | Whistler | 1997-12-09 | 2003-08-19 | 5 | | Slim | 1996-04-29 | 2003-08-19 | 7 | | Puffball | 1999-03-30 | 2003-08-19 | 4 | +----------+------------+------------+------+ Hope this is helpful !
Function to find dates in current week in mysql
MySQL YEARWEEK() returns year and week number for a given date.
Syntax: YEARWEEK(date_value,Mode)
Parameters or Arguments
- date_value
- A date or datetime value from which to extract the year and week.
- mode
- Optional. It is used to specify what day the week starts on. It can be one of the following:
mode Explanation Week Value 0 First day of the week is Sunday 0-53 1 First day of the week is Monday and the first week has more than 3 days 0-53 2 First day of the week is Sunday 1-53 3 First day of the week is Monday and the first week has more than 3 days 1-53 4 First day of the week is Sunday and the first week has more than 3 days 0-53 5 First day of the week is Monday 0-53 6 First day of the week is Sunday and the first week has more than 3 days 1-53 7 First day of the week is Monday 1-53
Example : select YEARWEEK(now());
The following statement will return the year and week number of the date 2016-05-19.
SELECT YEARWEEK(‘2016-05-19’);
Hope this help!
Order by Date Descending issue (Linq)
Issue :
Dim list As List(Of Eventlist) = (From d In EventList
Order By d.Status Descending, d.StartDate Descending,
Select d).ToList()
It gives me the date ordered by month and day, but doesn’t take year into consideration. for example:
12/31/2009
12/31/2008
12/30/2009
12/29/2009Needs to be more like:
12/31/2009
12/30/2009
12/29/2009
12/28/2009
Solution :
Dim list As List(Of Eventlist) = (From d In EventList
Order By d.Status Descending, Year(d.StartDate) Descending, Month(d.StartDate) Descending, Day(d.StartDate) Descending
Select d).ToList()
Hope it helps !Add Days to Javascript Date Object
To add days to javascript date object use following syntax
var dayOffset = 20;
var millisecondOffset = dayOffset * 24 * 60 * 60 * 1000;
december.setTime(december.getTime() + millisecondOffset);
Bootstrap and datepicker
How to check if the user enters the default datetime? VB.NET
In VB.NET if we pass nothing to date it will return default value like ” #12:00:00 AM# ‘
To check if date is not default date than following should be used
IfNotDate.MinValue = MyDate
Hope it helps
Rahul Bhatia
Comments