Re: ECPG - Timestamp to ascii Conversion PG version 7.4

Поиск
Список
Период
Сортировка
Искать

Re: ECPG - Timestamp to ascii Conversion PG version 7.4

От:
Michael Meskes <meskes@postgresql.org>
Дата:
On Thu, May 05, 2005 at 11:07:10AM -0700, Don Laurine wrote:
> We are currently transitioning to Postgresql 7.4 from Informix. IN ECPG,
> is there a Postgresql function which will convert the timestamp data
> type to a string equivalent.  INFORMIX has the dtcvasc function but I
> prefer not to use the -C compatibility option. I rather have a complete
> port and get away from INFORMIX.

There is. You can use PGTYPEStimestamp_from_asc instead. You just have
to link against pgtypeslib.

Michael
-- 
Michael Meskes
Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

ECPG - Timestamp to ascii Conversion PG version 7.4

От:
Don Laurine <donald.laurine@noaa.gov>
Дата:
We are currently transitioning to Postgresql 7.4 from Informix. IN ECPG,
is there a Postgresql function which will convert the timestamp data
type to a string equivalent.  INFORMIX has the dtcvasc function but I
prefer not to use the -C compatibility option. I rather have a complete
port and get away from INFORMIX.


-- 
Don Laurine 
NOAA, Northwest River Forecast Center
voice: (503) 326-7291 (ext. 323)

Re: ECPG - Timestamp to ascii Conversion PG version 7.4

От:
"Dann Corbit" <DCorbit@connx.com>
Дата:
template1=# \d bar
                 Table "public.bar"
  Column  |            Type             | Modifiers
----------+-----------------------------+-----------
 happened | timestamp without time zone |

template1=# select happened::varchar from bar;
        happened
-------------------------
 2005-05-05 11:19:38.066
 2005-05-05 11:19:40.082
 2005-05-05 11:19:41.097
(3 rows)

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of Don Laurine
> Sent: Thursday, May 05, 2005 11:07 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] ECPG - Timestamp to ascii Conversion PG version 7.4
> 
> We are currently transitioning to Postgresql 7.4 from Informix. IN
ECPG,
> is there a Postgresql function which will convert the timestamp data
> type to a string equivalent.  INFORMIX has the dtcvasc function but I
> prefer not to use the -C compatibility option. I rather have a
complete
> port and get away from INFORMIX.
> 
> 
> --
> Don Laurine
> NOAA, Northwest River Forecast Center
> voice: (503) 326-7291 (ext. 323)
> 
> ---------------------------(end of
broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)
FAQ