Received: from mx99.openu.ac.il (arbel.openu.ac.il [147.233.32.4]) by hub.org (8.9.2/8.9.1) with ESMTP id KAA00870 for ; Mon, 29 Mar 1999 10:58:31 -0500 (EST) (envelope-from herouth@oumail.openu.ac.il) Received: from talmon.openu.ac.il (talmon.openu.ac.il [147.233.32.11]) by mx99.openu.ac.il (Postfix) with ESMTP for id 077984B4AE; Mon, 29 Mar 1999 15:58:24 +0000 (Asia/Jerusalem) Received: from [147.233.148.145] (1169.pc.openu.ac.il) by talmon.openu.ac.il (Netscape Messaging Server 3.54) with ESMTP id AAA5DC; Mon, 29 Mar 1999 18:00:12 +0200 X-Sender: herouth@shaked.cc.openu.ac.il Message-Id: In-Reply-To: <36FF5B39.52CB4137@gameszone.net> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Date: Mon, 29 Mar 1999 18:00:00 +0200 To: rick@ricken.demon.co.uk, pgsql-general@postgreSQL.org From: Herouth Maoz Subject: Re: [GENERAL] Returning an integer from a date Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id KAA00872 At 12:51 +0200 on 29/03/1999, Rick Dearman wrote: > > I have a date field in a table, I want to create a function to >manipulate this date, however I want the date to come to me as an integer. > > Is this possible? Or do I have to get it as a char *string?? What kind of an integer do you need? You could have the "milliseconds since epoch" kind of number quite easily. Or do you need a number such as 19990301? Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma