On lau, 2007-07-28 at 17:12 -0300, Bruno Rodrigues Siqueira wrote: > where > > to_char( data_encerramento ,'yyyy-mm') > between '2006-12' and '2007-01'
assuming data_encerramento is a date column, try: WHERE data_encerramento between '2006-12-01' and '2007-01-31' gnari ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
