[thelist] SQL: Can you spot the error?
Dan Craciun
dcsquare at myrealbox.com
Tue Jul 15 02:06:23 CDT 2003
UPDATE news SET title = 'Krispy Kreme in Maple Grove Completed.f', date =
'2003/14/07', active = 1, article ='The new Krispy Kreme in xxxxx is now
open for business! xxxxx was awarded a sub-contract in the construction of
the popular doughnut franchise, and is currently in negations to help
construct a restaurant in xxxx.' WHERE news_id = 3
MYSQL stores data in yyyy-mm-dd format (or in yy-mm-dd). When you update or
insert a date, the separator can be "/", "-", " " and some others I think,
but you must supply the date in one of those forms (year-month-day).
Cheers,
Dan CRACIUN
More information about the thelist
mailing list