* zxcv
> Our programming crew does not give us (Web Services) access to Oracle. We
> of course don't care kuz' mySQL suits us fine. But now we have run into a
> pickle. They are handing us text cdf files for import. One of the fields
> they are giving us is in the following condition:
>
> 02-SEP-02
>
> We need to do a conversion of that to a `real' datetime format. I know of
> a function in php that will convert that but I need this in SQL only.
>
> Any ideas?
Asuming all dates are 20xx:
mysql> select
@d:='01-DEC-18',@d2:=concat('20',mid(@d,1,2),'-',field(mid(@d,4,3),
'JAN','FEB','MAR','APR','MAY','JUN','JUL','AUG','SEP','OCT','NOV','DEC'),'-'
,mid(@d,8,2)) as converted, @d2 + interval 1 second as proof;
--
Roger
---------------------------------------------------------------------
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
