Re: ECPG - Timestamp to ascii Conversion PG version 7.4

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)