Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > So this means that when you have YMD, that 03-01-01 is Jan 1, 2003? > > That's the idea.
I assume that the datestyle has to be set to YMD for this to work as outlined above, right, and that 97-01-01 will throw an error unless the datestyle is YMD. > BTW, is the second version of Greg's patch on your unapplied-patches > page the latest one? I wasn't keeping track. Yes, second one is most recent version. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend