| From: | Vaduvoiu Tiberiu <vaduvoiutibi(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | MySql week() method equivalent |
| Date: | 2010-11-18 13:07:59 |
| Message-ID: | 729759.62026.qm@web51303.mail.re2.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
I have a bit of a problem replacing the week() method from mysql in some of my queries. The equivalent function for week($date) would be "extract week from $date". All good until I found a mysql query where the week function is called with the second parameter like this: select week(date,3). Based on mysql site, second parameter means that : "Week 1 is the first week with more than 3 days this year(for second parameter=3)". I made a couple of tests with some dates on both mysql and postgresql and noticed that "select week(date,3)" and extract(week from date) sometime returns different values. Anyone has any ideea for a workaround on this issue??
Thanks
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Sabino Mullane | 2010-11-18 15:16:31 | Re: MySql week() method equivalent |
| Previous Message | Matthew Walden | 2010-11-18 09:06:34 | Re: Debugging PostgreSql queries |