Is there a way to compare current date with date stored in database in VARCHAR format?

Question

I have a set of date that i have stored in my database in varchar format. The reason for me using Varchar is because im using jquery datepicker.

Is there a way for me to compare the date with current date.

Possible duplicate http://stackoverflow.com/questions/5619202/converting-string-to-date-in-js — DevelopmentIsMyPassion, Mar 14 '13 at 07:37
@AshReva im not sure thats a duplicate. I wanted to compare the current date with date that i've stored in my database — user1852728, Mar 14 '13 at 07:53

jcubic · Answer 1 · 2013-03-14T08:22:13.700

0

You can try to use datejs library.

You can parse your string using Date.parse and then Date.compare to compare two dates.

$.get('date.php', function(date) {
    alert(Date.compare(Date.today(), Date.parse(date));
});

edited Mar 14 '13 at 08:22

answered Mar 14 '13 at 07:55

jcubic

61,973
54
229
402

Can you add some more content? At this point, it should have been a comment rather than an answer. I don't even see how it's related to the question. – John Dvorak Mar 14 '13 at 08:18

score 0 · Answer 2 · answered Mar 14 '13 at 08:55

you can use getDate, getMonth and getFullYear to get date, month and year for your date stored in varchar and current and compare them individually. The solution is not so elegant but will work.

var dt = new Date('2011-01-11'); //replace this hard coded date with one from database
var todaydate = new Date() //todays date

//i have added +1 in getMonth as its index start from 0. so if month is Jan then it returns 0 instead of 1. Hence i added +1 
if (dt.getDate() == todaydate.getDate() && dt.getMonth()+1 == todaydate.getMonth()+1 && dt.getFullYear() == todaydate.getFullYear())
{
    alert('match');
}
else
{
     alert('not match');
}

Also see this fiddle here

Is there a way to compare current date with date stored in database in VARCHAR format?

2 Answers2