Date - Subin's Blog

MySQL NOW() in JavaScript (UTC & Local)

April 4, 2014 JavaScript, MySQL

If you know MySQL, you will certainly know the NOW() function that outputs the current date and time with the timezone of the MySQL server. For easy use and compatibility, we use UTC time zone for storing time in database. If you are running a web app that comply with MySQL, then you need the date function as same as the NOW().

So, I will give you a small function that return the same value as MySQL’s NOW() function in both UTC and local time. There are 2 versions of this function, one little big and the other very short (1 line of code). The shorter one is supported by modern browsers and the other is supported by all browsers.

... [READ MORE]

How to get Current Time and date in Javascript

May 7, 2013 JavaScript

This tutorial will help you to get current date and time at which the function is executed. Here is the function:

function ctime(){
var currentdate = new Date();
var time=currentdate.getFullYear()+"-"+(currentdate.getMonth()+1)+"-"+currentdate.getDate()+" "+currentdate.getHours()+":"+currentdate.getMinutes()+":"+currentdate.getSeconds();
return time;
}

Just print out ctime() function to get the date and time in the format YEAR/MONTH/DAY HOUR:MINUTE:SECOND

Explanation :

new Date() function prints out the current date and time in a disorderly way. You can order it in any way as I did in the time() function.

currentdate.getFullYear() will get the year from new Date() which is in the variable currentdate

currentdate.getMonth() will get the month from new Date() function. The program adds 1 to the month because Javascript always count the month from . So we should add a +1.

currentdate.getDate() will get the day of the month in which the function is executed.

currentdate.getHours() will give the Hour of the time.

currentdate.getMinutes() will give the Minute in which the script is executed.

currentdate.getSeconds() This function will give the seconds of the time at which the script is executed.

... [READ MORE]

The best age calculation code in PHP

May 2, 2013 PHP

Age calculation is a tricky calculation especially in Programming Languages. I’m going to tell you a simple way to find out age in PHP. This is a simple function that will calculate age if it is given a birthday date in the format date/month/year. For example : 20/01/2000 or 04/12/1990
Here is the function :

function age($birthday){
list($day,$month,$year) = explode("/",$birthday);
$year_diff = date("Y") – $year;
$month_diff = date("m") – $month;
$day_diff = date("d") – $day;
if ($day_diff < 0 && $month_diff==0){$year_diff–;}
if ($day_diff < 0 && $month_diff < 0){$year_diff–;}
return $year_diff;
}
... [READ MORE]

MySQL NOW() in JavaScript (UTC & Local)

How to get Current Time and date in Javascript

The best age calculation code in PHP

Follow/Subscribe

Subdomains

Past