Many thanks for the, Richard... You wrote:
> > I'm not so sure what you are asking here but from this statement, > > More importantly are there functions in mySQL I can call to convert a > standard date, ie "yyyymmdd" to the expected mySQL value?. Yeah, I was a bit vague :-) But your example provided the clue- I had neglected the string delimiters :-( I had coded SET myDate = yyyymmdd I should have coded SET mydate = 'yyyymmdd' which worked. Again, many thanks Pierre --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
