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