Newbie Q: How to deal with date/time with libpq or ecpg? - Mailing list pgsql-interfaces

From Michael Zhang
Subject Newbie Q: How to deal with date/time with libpq or ecpg?
Date
Msg-id 36D41D02.F4415E1F@insuremarket.com
Whole thread Raw
Responses Re: [INTERFACES] Newbie Q: How to deal with date/time with libpq or ecpg?  (Michael Meskes <Michael_Meskes@topmail.de>)
List pgsql-interfaces
Hi, I am new to the postgreSQL.

I would like to set up my own WWW server using linux/postgreSQL. Some of

my web applications use many date/time manipulations. For example, I
would like to dynamicly display a date of birth column with specified
format. I could do it on Oracle like this:
    SELECT to_char(DateofBirth, 'MM-DD-YYYY') from Employee_tbl where
First_nm = 'Mike';
Then I could use Pro*C to retrive the result into a char[] array.

But how can I receiver this kind of information with specified format in

postgreSQL by using libpq or ecpg?

Thanks in advance!
Mike


pgsql-interfaces by date:

Previous
From: Tom Lane
Date:
Subject: Re: [INTERFACES] problems with pgaccess
Next
From: "jose' soares"
Date:
Subject: Re: [INTERFACES] xmin field in a newly created table.