X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 8588E3A62C3
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 28 Jan 2005 14:27:42 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 55740-07
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 28 Jan 2005 14:27:29 +0000 (GMT)
Received: from smtp-1.indo.net.id (smtp-1.indo.net.id [202.159.32.91])
	by svr1.postgresql.org (Postfix) with SMTP id 17CFD3A6291
	for <pgsql-sql@postgresql.org>; Fri, 28 Jan 2005 14:27:28 +0000 (GMT)
Received: (qmail 1001 invoked from network); 28 Jan 2005 21:27:25 +0700
Received: from smtp.indo.net.id (202.159.32.81)
	by smtp-1.indo.net.id with SMTP; 28 Jan 2005 21:27:25 +0700
Received: (qmail 7495 invoked from network); 28 Jan 2005 21:27:21 +0700
Received: from unknown (HELO middinks) (202.159.122.104)
	by smtp.indo.net.id with SMTP; 28 Jan 2005 21:27:21 +0700
Message-ID: <03a001c50545$6bd942d0$1f00a8c0@middinks>
From: "Muhyiddin A.M Hayat" <middink@indo.net.id>
To: <pgsql-sql@postgresql.org>
Subject: Calendar Function
Date: Fri, 28 Jan 2005 22:26:48 +0800
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_039D_01C50588.750FD470"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.431 tagged_above=0 required=5 tests=AWL,
	DNS_FROM_RFC_WHOIS, HTML_60_70, HTML_MESSAGE
X-Spam-Level: 
X-Archive-Number: 200501/306
X-Sequence-Number: 20094

This is a multi-part message in MIME format.

------=_NextPart_000_039D_01C50588.750FD470
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Dear All,

How to create Calendar Function or Query. I would like to display date =
form yyyy-mm-dd to yyyy-mm-dd or display date in one Month

e.g:

    date
------------
 2005-01-01
 2005-01-02
 2005-01-03
 2005-01-04
 2005-01-05
 2005-01-06
 2005-01-07
 2005-01-08
 2005-01-09
 2005-01-10
 2005-01-11
 2005-01-12
 2005-01-13
 2005-01-14
 2005-01-15
 2005-01-16
 2005-01-17
 2005-01-18
 2005-01-19
 2005-01-20
 2005-01-21
 2005-01-22
 2005-01-23
 2005-01-24
 2005-01-25
 2005-01-26
 2005-01-27
 2005-01-28
 2005-01-29
 2005-01-30
 2005-01-31


------=_NextPart_000_039D_01C50588.750FD470
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2523" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Dear All,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>How to create Calendar Function or =
Query. I would=20
like to display date form yyyy-mm-dd to yyyy-mm-dd or display date in =
one=20
Month</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>e.g:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;=20
date<BR>------------<BR>&nbsp;2005-01-01<BR>&nbsp;2005-01-02<BR>&nbsp;200=
5-01-03<BR>&nbsp;2005-01-04<BR>&nbsp;2005-01-05<BR>&nbsp;2005-01-06<BR>&n=
bsp;2005-01-07<BR>&nbsp;2005-01-08<BR>&nbsp;2005-01-09<BR>&nbsp;2005-01-1=
0<BR>&nbsp;2005-01-11<BR>&nbsp;2005-01-12<BR>&nbsp;2005-01-13<BR>&nbsp;20=
05-01-14<BR>&nbsp;2005-01-15<BR>&nbsp;2005-01-16<BR>&nbsp;2005-01-17<BR>&=
nbsp;2005-01-18<BR>&nbsp;2005-01-19<BR>&nbsp;2005-01-20<BR>&nbsp;2005-01-=
21<BR>&nbsp;2005-01-22<BR>&nbsp;2005-01-23<BR>&nbsp;2005-01-24<BR>&nbsp;2=
005-01-25<BR>&nbsp;2005-01-26<BR>&nbsp;2005-01-27<BR>&nbsp;2005-01-28<BR>=
&nbsp;2005-01-29<BR>&nbsp;2005-01-30<BR>&nbsp;2005-01-31</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_039D_01C50588.750FD470--