#frrfu

Yes, Timmy, you COULD use substr on a timestamp in pgsql 8.1. No, Timmy, you can't in 8.4+. Should you have? Probably not. Maybe you should have used to_char instead as it will make stripping the time zone out easier than summarily dumping it with substr. Plus, you get to define the timestamp's format. Yes, I believe you could have defined the table without using timestamp + zone, but the vendor made the db, we're just practicing voodoo on it. Oh, and yes, substr(field,first char,for chars) is now substring(field [first char] [for chars]).