We help IT Professionals succeed at work.

sql statement convrt 4/1 to 4.1

teera
teera asked
on
colum a is    4/1  7/21  84/2  how can  i change to  4.1  7.21 84.2
Comment
Watch Question

Commented:
REPLACE function of MySQL can help.
Commented:
Sorry. The above link is wrong. Here's the right REPLACE.
IT Supervisor
Top Expert 2009
Commented:
gnoon is exactly correct.  Example:

  SELECT REPLACE(date, '/', '.') FROM your_table;

Warning - this replaces *all* occurances of '/' with '.' in your field.