MySql – selektiranje mjeseca i godine iz datuma istovremeno

Problem: treba selektirati iz MySql baze vrijeme i godinu iz polja datum radi uspoređivanja. Npr. za datum 28.12.2016.

Rješenje:

EXTRACT(YEAR_MONTH FROM datum)

Query vraća kao rezultat izraz: 201612

This entry was posted on Monday, December 5th, 2016 at 3:45 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.