Trouble with dates

[phrozenflame]

On my users table on my mysql db i have a field called "lastlogin". This is the date when the person last logged on my site and is in the format  "hh:mm:ss - dd:mm:yyyy"  eg"13:46:28 - 18/11/2005"


I want to make something so I can see who hasnt logged in within (x) amount of days.

I know know to explode it so I can get just the 18/11/2005 bit but how would I make it so I can list only those entrys that havent logged in within (x) days?

[emehrkay]

is it storing it in the db as

hh:mm:ss - dd:mm:yyyy

or with mysql's datetime

yyyy-mm-dd hh:mm:ss

??

[phrozenflame]

Like this storing
hh:mm:ss - dd:mm:yyyy

[emehrkay]

is it just a varchar field?

if so change it to datetime

and when you put it in the db, make sure you use this format

yyyy-mm-dd hh:mm:ss

that will make it easier to do date calculations in your queries.

[phrozenflame]

Thanks a lot