Hi! I am migrating a bunch of cf applications that are using access as a backend, and pgadmin is converting all date/time data types to date data types on the postgres side. I want to convert these columns to the appropriate time data types, but am unable to using CAST( according to the pop-up window.) Is there another way? Thanks! -- Shannon Peevey UNT-Central Web Support [EMAIL PROTECTED] 940-369-7786 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster