MYSQL – lokalizacija datuma

Problem:

trebamo dobiti naziv za mjesec iz nekog datuma

Rješenje:

MONTHNAME(STR_TO_DATE(MONTH(datum_i_vrijeme), ‘%m’))

Međutim, to nam daje engleske nazive mjeseci. Da bi dobili hrvatske moramo postaviti sljedeći upit na bazu:

SET lc_time_names = ‘hr_HR’

This entry was posted on Monday, October 13th, 2014 at 4:46 pmand is filed under MYSQL Database Development. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.

Comments are closed.