CODE To enter a TIMESTAMP(8) into a mySQL database
Posted: Wed Mar 12, 2003 5:32 am
have a question that no-one in this database either knows or like a few people that have responded to my question in the forum have given me other ways in which still dont work.
Please see
http://www.devnetwork.net/forums/viewto ... highlight=
All i really want to know is how to store this from an input box
$member_date_of_birth
Which has been typed in for example "23-10-1980"
in to a mySQL database as a TIMESTAMP(.
And how to get it out again.
back to $db_member_date_of_birth
so i can output it on another page as
"Monday 23rd October 1980"
Its simple, but yet no-one knows how to do it.
The reason i want it to be a timestamp is because i need it to be sorted within the database, when i run a query.
And also so i can manuiplate the date for example adding two dates together and working out the age of a member.
Can you help? Thanks for reading this anyway.
Cheers,
SteJ.
Please see
http://www.devnetwork.net/forums/viewto ... highlight=
All i really want to know is how to store this from an input box
$member_date_of_birth
Which has been typed in for example "23-10-1980"
in to a mySQL database as a TIMESTAMP(.
And how to get it out again.
back to $db_member_date_of_birth
so i can output it on another page as
"Monday 23rd October 1980"
Its simple, but yet no-one knows how to do it.
The reason i want it to be a timestamp is because i need it to be sorted within the database, when i run a query.
And also so i can manuiplate the date for example adding two dates together and working out the age of a member.
Can you help? Thanks for reading this anyway.
Cheers,
SteJ.