Received: from mail.agria.hu (qmailr@agria.hu [194.196.126.2]) by hub.org (8.9.3/8.9.3) with SMTP id OAA23703 for ; Tue, 30 Nov 1999 14:24:00 -0500 (EST) (envelope-from redax@mail.agria.hu) Received: (qmail 6788 invoked by uid 1000); 30 Nov 1999 19:15:21 -0000 Date: Tue, 30 Nov 1999 20:15:21 +0100 From: Zsolt Varga To: pgsql-sql@postgresql.org Subject: date function questions... Message-ID: <19991130201521.A6659@lupus.agria.hu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.95.3i Hi! I'm try to implement some kind of comany database into postgres, but unfortunatly I don't know the how to solve the following porblems: - how to test is any date in the same month as we are, or month '1999.10' for example? - how to convert 'seconds' to 'hh:mm:ss' format? (int) --> (time) select time(5); returns '01:00:05' am I triggered a bug? anyway I'd like to write this kind of date/time functions, and I tried too... but without any success... could somebody send me some kind of examples to handle date/datetime/time/timestamp from C function.. (or either plpgsql.) Many thanks, Redax