Hello -
I am writing date/time values into the database by assigning this variable in the code:
@$stamp = date("D M d, Y h:i A");
It generates something like this:
Sun Jun 30, 2002 11:25 AM
and then inserting the stamp variable into a VARCHAR field in my mysql database - so now i'm thinking i screwed up - I need to perform comparisons on the date field - like show dates where Greater than 'Sun Jun 30, 2002 11:25 AM' and LESS than 'Sun Jun 30, 2002 06:25 PM'
am i pretty much out of luck? or are there options still open? I'm kind of a newbie if you couldn't already tell : )...could i actually just change the field type in mysql from VARCHAR to DATETIME or something like that? or would that garble up my existing data?
