Replace string with your column name in sql

Axapta Code solutions   Education and Entertainments  Earn Money its Real  Experience of knowledge  Imortant Weblink collections   Fun and Entertainment   God thoughts   Get Ways to Invest your money   Products overview and details

Replace string with your column name in sql

Replace '2011-06-20T00:00-04:00' with your column name. 
SELECT SUBSTR('2011-06-20T00:00-04:00',1,INSTR('2011-06-20T00:00-04:00','T')-1)||' '||SUBSTR('2011-06-20T00:00-04:00',INSTR('2011-06-20T00:00-04:00','T')+1,LENGTH('2011-06-20T00:00-04:00'));