Re: Get Date value from Datum - Mailing list pgsql-hackers

From Hannes Eder
Subject Re: Get Date value from Datum
Date
Msg-id 154e089b0811032335r2c490149m5afa82133f97d031@mail.gmail.com
Whole thread Raw
In response to Re: Get Date value from Datum  (imad <immaad@gmail.com>)
List pgsql-hackers
On Tue, Nov 4, 2008 at 12:30 AM, imad <immaad@gmail.com> wrote:
> What do you want to print? The integer value or the date string like
> "29-01-2008". Use the date_out function to convert your value to date.
>
> --Imad
>
> On Tue, Nov 4, 2008 at 10:19 AM, Zhe He <henryhezhe2003@gmail.com> wrote:
>> Hi,
>> I met some problem with get date type value
>> from a table. I have a Datum which stores this
>> value as an integer and I want to get its date
>> value. Is there anyway that I can print it out?

Maybe inspecting the code of debugtup also helps, see

src/backend/access/common/printtup.c

(http://git.postgresql.org/?p=postgresql.git;a=blob;f=src/backend/access/common/printtup.c#l504)

--Hannes


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Hot standby v5 patch - restarted replica changes to warm standby mode
Next
From: "Pavel Stehule"
Date:
Subject: Re: plperl needs upgrade for Fedora 10