-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Yeah, that was my mistake. Sorry about that. I've changed it to 9.
Roger Baklund wrote: | * Paul DuBois | [...] | |>>Jan 02, 2004 | | [...] | |>By the way, why do you have MID(datecol,8) rather than MID(datecol,9)? | | | There was no comma in the dates in his original post. He should use | MID(datecol,9) if there actually is a comma in his dates, though | MID(datecol,8) will also work in this case because of the space preceeding | the year. | | -- | Roger |
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFAEBylIcIs3CP5DxwRAkAJAJ9xpqbZNiFj+56rHC8266/Jg61LVQCggGU0 U2MNvh2up5qNaKZCXn0MwDY= =Nyzr -----END PGP SIGNATURE-----
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]