On Fri, 2004-09-03 at 15:43 +1000, James Gregory wrote: > Dear List, > > It's been a long, long time since I've used mysql and I happen to need > to work with dates. Amongst my many, demanding requirements is the > ability to enter a literal date.
Found it here: http://mckoi.com/database/maillist/msg02738.html This: mysql> select DATE '2002-10-01'; +------------+ | 2002-10-01 | +------------+ | 2002-10-01 | +------------+ 1 row in set (0.00 sec) is the magical incantation. James. -- James Gregory <[EMAIL PROTECTED]>
signature.asc
Description: This is a digitally signed message part
-- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
