Klint Gore <[EMAIL PROTECTED]> writes: > I think this is what I was getting at. In my timezone 'Australia/NSW', > we have daylight savings. Is that used any way when the calculation > happens or the result is displayed?
Absolutely. The examples Bruce and I have been throwing around assume US Eastern timezone, because that's where we live, but the code should adapt to your local zone rules wherever you are. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match