RE: [SQL] order by day or month, etc

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Leo Xavier Sent: 03 January 2001 00:22 To: [EMAIL PROTECTED] Subject: [SQL] order by day or month, etc Hello first time I post something... good morning everyone! short presentation: Leo Xavier, Lisbon

[SQL] order by day or month, etc

Hello first time I post something... good morning everyone! short presentation: Leo Xavier, Lisbon - Portugal, 17 years, my home-made site: www.megabenfica.com Sql7, win 2000... The question: How for example do I select all entrys from a certain month (of a certain year, of course) ? Or from a

Re: [SQL] order by day or month, etc

Hello Leo, which version of PostgreSQL are you running? I tested: select to_char(abm_dat, 'DD/MM/') AS new_date from t_dummy; And it works fine: new_date 31/03/1992 15/06/1994 11/09/1993 19/11/1993 ... Regards, Jens Leo Xavier schrieb: [...] doing this: SELECT