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

2001-01-03 Thread Francis Solomon
27;1999-09-30'; Hope this helps. Francis Solomon > -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 > f

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

2001-01-02 Thread Jens Hartwig
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

[SQL] order by day or month, etc

2001-01-02 Thread Leo Xavier
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 ce