teste
Sql
code posted
by
teste
created at 15 Apr 21:58
Edit
|
Back
  1
2
3
4  | 
  SELECT 
  DISTINCT CONCAT(SUBSTRING(`dat_periodo`, 1, 4), '-', SUBSTRING(`dat_periodo`, 5, 2), '-01') AS `dat_periodo`
FROM
  `${DATABASE_NAME}`.`${NOME_TABELA}` | 
162 Bytes in 2 ms with coderay