Re: [GENERAL] Working with dates

2007-07-05 Thread Ranieri Mazili
Original Message Subject: [GENERAL] Working with dates From: Ranieri Mazili <[EMAIL PROTECTED]> To: pgsql-general@postgresql.org, [EMAIL PROTECTED] Date: 5/7/2007 16:00 Hello, I need to do the following select: Number of days of month - weekends - holydays So this query will

Re: [GENERAL] Working with dates and queries

2001-09-14 Thread Peter Eisentraut
http://www.de.postgresql.org/users-lounge/docs/7.1/postgres/ Krog, Kenneth writes: > > I am attempting to do a query for a specific month based of a response for a > web site using php as the engine. > The syntax of the sql is simple > > "SELECT * FROM table WHERE MONTH(fieldname)=08;" > > note: