MySql: STR_TO_DATE – konverzija datuma iz stringa u date

Problem:

U bazi imamo datum kao string u formatu d.m.YYYY i treba ga pretvoriti u MySql formatirani datum
npr. datum 15.4.2010 treba pretvoriti u 2010-04-15

Rješenje: 

SELECT STR_TO_DATE('15.4.2010','%d.%m.%Y') as datum ...

rezultat: 2010-04-15

This entry was posted on Tuesday, May 17th, 2011 at 4:18 pmand is filed under MYSQL Database Development. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.