Re: [GENERAL] Returning an integer from a date - Mailing list pgsql-general

From Adriaan Joubert
Subject Re: [GENERAL] Returning an integer from a date
Date
Msg-id 36FF626F.EA9E6B63@albourne.com
Whole thread Raw
In response to Returning an integer from a date  (Rick Dearman <rdear@gameszone.net>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Rick Dearman
Date:
Subject: Returning an integer from a date
Next
From: Gerard Saraber
Date:
Subject: backing up pgsql