Play Flash Games


© 2007 Red Computer
HTML Howto, CSS Howto, JavaScript Howto, PHP Howto, Windows Howto
Google

Convert Datetime to JS Date


MySQL stored datetime as 2007-11-19 08:15:23, SQL Server stored datetime as 2006-12-30 18:05:56.000 but JavaScript Date() return Sat Dec 30 18:05:56 UTC+0700 2006. If you want to compare date in JavaScript, let use this function :

<script language=JavaScript>
function dt2js(timestamp) {
	var jsdt =new Date();

	var dd=timestamp.split(" ");
	var d=dd[0].split("-");
	if (!dd[1]) dd[1]="00:00:00.000";
	var tt=dd[1].split(".");
	var t=tt[0].split(":");

	jsdt.setFullYear(d[0],d[1]-1,d[2]);
	if (!tt[1]) tt[1]="000";
	jsdt.setHours(t[0],t[1],t[2],tt[1]);
	return jsdt;
}

// try to print to see the result
document.write(dt2js('2006-12-30 18:05:56.000'));
</script>

In input datetime is 2006-12-30 18:05:56.000 This is the output result :





Visitor's Comment

Post a Comment
Comment
Name :
E-mail :

HOME | HTML | CSS | JavaScript | PHP | XML | SQL | Virus Fix | Windows | Downloads | Links