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
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