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)