I'm trying to import data from a sybase bcp (tab separated dump) and am encountering a really odd datetime type: Mar 27 1994 12:00:00:000AM I've been looking in the books but haven't found anything yet and see nothing in any of the PostgreSQL docs. Anyone have any idea how I can bring this data in without having to write something to read from the sybase table and write to the postgres table? I'd like to use copy to keep things simple. Vince. -- ========================================================================== Vince Vielhaber -- KA8CSH email: [EMAIL PROTECTED] http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directory http://www.camping-usa.com Online Giftshop Superstore http://www.cloudninegifts.com ========================================================================== ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])