Message-ID: <36D38019.BD27969E@insuremarket.com>
Date: Tue, 23 Feb 1999 23:29:13 -0500
From: "Michael Zhang" <mzhang@ifscorp.com>
Organization: Interactive Insurance Services
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: Newbie interface Q: How to deal with date/time with libpq or ecpg?
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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_date(DateofBirth, 'MM-DD-YYYY') from Employee_tbl where
First_nm = 'Mike';

But how can I receiver this kind of information with specified format in
postgreSQL by using libpq or ecpg?

Thanks in advance!
Mike