"Nick Addington" <[EMAIL PROTECTED]> writes: > The following code works in 8.0.4 but fails in 8.1.0: > select to_char('1:00 pm'::time,'HH:MM AM');
I'm inclined to think that disallowing AM/PM for intervals was a mistake --- if we allow both HH and HH24 (which we do) then the various flavors of AM/PM seem reasonable to allow as well. Bruce, did you have a specific rationale for that? I notice the code now specifically forces HH to be treated as HH24 in the interval case, which was not so before 8.1; we would need to revert that change as well to continue supporting TIME cases reasonably. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster