Simply put, I'm REALLY hungover, and want to die...
However, before I go home.. I have to convert:
(string)3/MAY/07 -- (date for MySQL)2007-05-03
google is confusing me...
NEVER drinking again.
Tris...
--
When a person can no longer laugh at himself, it is time for others to
laugh at him.
(string)3/MAY/07 -- (date for MySQL)2007-05-03
select str_to_date('3/MAY/07','%e/%M/%y')
from daTable...
;o)
� The WDVL Discussion List from WDVL.COM �
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface
sorry, it's for inclusion into a db.. so I need to convert the date
before I create my MYSQL satement...
On 25/01/07, r937 [EMAIL PROTECTED] wrote:
(string)3/MAY/07 -- (date for MySQL)2007-05-03
select str_to_date('3/MAY/07','%e/%M/%y')
from daTable...
;o)
� The WDVL
sorry, it's for inclusion into a db.. so I need to convert the date
before I create my MYSQL satement...
no you don't ;o)
insert into mytable ( ... mydatecol, ... )
values ( ... , str_to_date('3/MAY/07','%e/%M/%y'), ... )
also, please be kind enough to trim your replies
thanks
rudy
Firefox is again aping the Sorcerer's Apprentice, and re-opening
with more windows than it had when it closed. Then I solved it
by taking all the add-ons out of Thunderbird, and have abandoned
Thunderbird (it is still on the machine but has no extensions of
its own).
I found 'Down them
Quoting r937 [EMAIL PROTECTED]:
sorry, it's for inclusion into a db.. so I need to convert the date
before I create my MYSQL satement...
no you don't ;o)
insert into mytable ( ... mydatecol, ... )
values ( ... , str_to_date('3/MAY/07','%e/%M/%y'), ... )
also, please be kind enough to
also, please be kind enough to trim your replies
awww, be kind to the guy, he's hung over...
i thought my request was actually very polite
and i'm afraid there ~is~ no excuse for ignoring list etiquette
as for your php, did you see my STR_TO_DATE solution?
why would you want to take time
Quoting r937 [EMAIL PROTECTED]:
also, please be kind enough to trim your replies
awww, be kind to the guy, he's hung over...
i thought my request was actually very polite
yup, it was, one of these days we'll invent voice-based email and the
tones of our voices will be heard, leaving no