Hello: I'm using postgres 7.0.2. When I use date_part('day', date) sometimes I get wrong values. Ie: and date_part('day', '1999-3-28')=27 and date_part('day', '2000-3-26')=25 Is it a bug? Is there any SQL equivalent function? -- Salvador Mainé ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
- Re: [SQL] date_part bug? Salvador Mainé
- Re: [SQL] date_part bug? Richard Huxton