karly@xxxxxxxxxxxxx writes: > Yes, that's what I'm looking for. How can I create an IMPLICIT > cast from date to my custom type? IOW, if I assing a date to a > varible of my type, it will be converted to the format I specify. Make a function that does the conversion the way you want, and then create a cast that uses the function (see CREATE CAST). regards, tom lane