PHP Date & MySQL

Hi all, just a quick question, can I enter a date into MySQL using a PHP date formatted as: Friday 29th July 2011 - will MySQL intelligently concert this to it’s date? I’m not at my computer at the moment to give this a try but trying to brainstorm some ideas of how to do a couple of things…any help or pointers will be appreciated greatly…

nope :slight_smile:

date values must be entered in numeric year-month-day sequence

the separator is optional, and can be any character in a string, or you can use a single number

all of the following are valid –

‘2011-07-24’
‘2011/07/24’
‘2011@07@24’
‘2011.07.24’
‘2011|07!24’
‘20110724’
20110724

note the last one is not a string

Hey dude, thanks for the prompt reply, a massive help. Thank you again :slight_smile: