Re: How to find out the weekday from a date???
От | Mitch Vincent |
---|---|
Тема | Re: How to find out the weekday from a date??? |
Дата | |
Msg-id | 006701c10ecf$d4e374a0$1251000a@Mitch обсуждение исходный текст |
Ответ на | How to find out the weekday from a date??? (Jose Manuel Lorenzo Lopez <jose-manuel.lorenzo-lopez@ica.conti.de>) |
Список | pgsql-general |
I modified that query to use the names in a table I have (date columns) and the query worked fine... What version of PG are you using? -Mitch ----- Original Message ----- From: "Jose Manuel Lorenzo Lopez" <jose-manuel.lorenzo-lopez@ica.conti.de> To: "PGSQL" <pgsql-general@postgresql.org> Sent: Tuesday, July 17, 2001 10:24 AM Subject: [GENERAL] How to find out the weekday from a date??? > Hello PG's, > > I want to extract the weekday of a given 'date' type field in my table > when selecting. How can I do this? > > For example in a table "bschft_days" filled with values with type 'date' > > I want to select all the days within the month 'march' and output the respective > weekday. I tryed this: > > select extract(dow from timestamp(day)), day, userid from bschft_days where date_part('month', day) = '3'; > > But it only tells me: > > ERROR: parser: parse error at or near "dow" > > :( > > Any ideas?? > > Thanks a lot in advance! > > Best Regards / Mit freundlichen Grüßen / Un saludo > > José Manuel lorenzo López > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html >
В списке pgsql-general по дате отправления: