SouzaMarcel0

select
		to_char(datum, 'yyyymmdd')::int as sk_data,
		datum as data_completa,
		extract(year from datum) as nr_ano,
		extract(month from datum) as nr_mes,
		to_char(datum, 'TMmonth') as nm_mes,
		extract(day from datum) as nr_dia_mes,
		to_char(datum, 'TMday') as nm_dia_semana,
		extract(doy from datum) as nr_dia_ano,