Re: Get Date value from Datum

From: imad <immaad(at)gmail(dot)com>
To: "Zhe He" <henryhezhe2003(at)gmail(dot)com>, "PG Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Get Date value from Datum
Date: 2008-11-03 23:30:33
Message-ID: 1f30b80c0811031530t5aff4f61g5c893c6b6bebcef5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)gmail(dot)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?
>
> Best Regards,
> Zhe HE
> TEL: (001) 646-789-3008
> Address:965 Amsterdam Avenue,
> New York, NY 10025
>
> Master Student, CS Dept.
> Columbia University
> www.columbia.edu/~zh2132
> -------------------------------------------
> 07 Alumni
> Bachelor of Eng, BUPT
> www.bupt.edu.cn
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2008-11-03 23:39:45 Re: Bitmap Indexes patch (was Re: Bitmap Indexes: request for feedback)
Previous Message Simon Riggs 2008-11-03 23:28:35 Re: Bitmap Indexes patch (was Re: Bitmap Indexes: request for feedback)