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@xxxxxxxxxx Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL! ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org