Editing ray

Title / Description

Code
SELECT DISTINCT CONCAT(SUBSTRING(`dat_periodo`, 1, 4), '-', SUBSTRING(`dat_periodo`, 5, 2), '-01') AS `dat_periodo` FROM `${DATABASE_NAME}`.`${NOME_TABELA}`

Author

Highlight as C C++ CSS Clojure Delphi ERb Groovy (beta) HAML HTML JSON Java JavaScript PHP Plain text Python Ruby SQL XML YAML diff code