postgres doubt

Question

postgres doubt

Renjith mamman-233609

Grasshopper

Points: 10
More actions
May 18, 2005 at 6:14 am

#167036

hi all
if there any function in postgres to get the number of days when we supplay month and year

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

sushila SSC-Dedicated Points: 35293 More actions · Answer 1

You may want to do a datediff between the first day of the month you want the # of days for and the first day of the following month!

What is postgres ?

**ASCII stupid question, get a stupid ANSI !!!**

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 2

PostgreSQL is a free and open-source DBMS, but unlike MySQL it is a good implementation of SQL and about as complete as "the big ones". I do not know why soneone is asking questions about it here at a SQL Server site though.

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/

sushila SSC-Dedicated Points: 35293 More actions · Answer 3

I remain amazed at how much I learn from this site everyday - Chris - do you know EVERYTHING ?!

For Renjith - you may want to check this link:

http://techdocs.postgresql.org/techdocs/faqdatesintervals.php

**ASCII stupid question, get a stupid ANSI !!!**