comparing todays date with date from sqlite db

what i want to do is compare todays date using var date=new Date(); to a date ive set in an sqlite db

basically eg:

var date=new Date();
 
if(date >= win.summerstartsdate)
 
{ // summer has started}

but i'm not sure how i would structure the date in the db eg 01:06:2012 or 20120601 etc so that it would match the output from new Date and be able to be compared by a greater than or less than operator

i'm not sure where to start

this works perfectly for me

newdate ='2011-05-04'? 
// newdate is the result of a db query
 
var date = new Date();
date = date.getTime();
date = date/1000;
 
// date = 1351002562
 
var newdate = strtotime(newdate);  // returns earller
 
//newdate = 1304460000
 
if(date >= newdate)
{ 
alert('later');
//do stuff
}
 
if(date <= newdate)
{ 
alert('earlier');
//do stuff
}

Hello Adrian,

you can set current date formate like....

var date = new Date();
date = dateFormat(date, "dd:mm:yyyy");

var win = Titanium.UI.createWindow({

title:'Date Comparison',

backgroundColor:'#fff'

});

var db = Titanium.Database.open('mydb');

db.execute('CREATE TABLE IF NOT EXISTS date_table (ID INTEGER, dbdate date)');

db.execute('INSERT INTO date_table (ID, dbdate ) VALUES(?,?)',1,'April 25, 2005');

db.execute('INSERT INTO date_table (ID, dbdate ) VALUES(?,?)',2,'December 25, 2005');

var rows = db.execute('SELECT * FROM date_table');

var dat1= db.execute('SELECT dbdate FROM date_table where ID=1').toString();

var dat2= db.execute('SELECT dbdate FROM date_table where ID=2').toString();

if (dat2>=dat1 ) {

Ti.API.info('its Summer');

} else{

Ti.API.info('Bug In Titanium Dates');

};

win.open();