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@xxxxxxxxxxxxxx [mailto:pgsql-general-
> owner@xxxxxxxxxxxxxx] On Behalf Of Don Laurine
> Sent: Thursday, May 05, 2005 11:07 AM
> To: pgsql-general@xxxxxxxxxxxxxx
> Subject: 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@xxxxxxxxxxxxxx)
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
