Received: from cap-ferrat.albourne.com (IDENT:root@cap-ferrat.albourne.com [195.89.178.227]) by hub.org (8.9.2/8.9.1) with ESMTP id GAA71487 for ; Mon, 29 Mar 1999 06:22:42 -0500 (EST) (envelope-from a.joubert@albourne.com) Received: from albourne.com (akamas.albourne.com [195.212.241.254]) by cap-ferrat.albourne.com (8.9.3/8.9.3/Albourne/2.4) with ESMTP id MAA06022; Mon, 29 Mar 1999 12:22:37 +0100 (BST) Sender: a.joubert@albourne.com Message-ID: <36FF626F.EA9E6B63@albourne.com> Date: Mon, 29 Mar 1999 12:22:23 +0100 From: Adriaan Joubert Organization: APL Financial Services (Overseas) Ltd X-Mailer: Mozilla 4.5 [en] (X11; U; OSF1 V4.0 alpha) X-Accept-Language: en MIME-Version: 1.0 To: rick@ricken.demon.co.uk CC: pgsql-general@postgreSQL.org Subject: Re: [GENERAL] Returning an integer from a date References: <36FF5B39.52CB4137@gameszone.net> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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?? > Get it in a binary cursor and you can get it as a julian date (centred around 2000). I handle all my dates as integers. Adriaan