String to date in MySQL

[klazuzu2]

Hi,

I have a date string in MySQL (varchar) in the format YYYYMMDDDHHMM (saved from a xml document) . I would like to convert the string to give me the format DD.MM.YYYY HH:MM when i do a select on the string.

Any ideas?

[ronverdonk]

This is a MySQL question, so I'll move the thread.

Hi,

I have a date string in MySQL (varchar) in the format YYYYMMDDDHHMM (saved from a xml document) . I would like to convert the string to give me the format DD.MM.YYYY HH:MM when i do a select on the string.

Any ideas?

Welcome to TSDN!

Try this one

SELECT DATE_FORMAT(STR_TO_DATE('200802281011','%Y%m%d %h%i'), '%d.%m.%Y %H:%i');

results in 28.02.2008 10:11

Ronald