Calendar Function

From: "Muhyiddin A(dot)M Hayat" <middink(at)indo(dot)net(dot)id>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Calendar Function
Date: 2005-01-28 14:26:48
Message-ID: 03a001c50545$6bd942d0$1f00a8c0@middinks
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message friendVU admin 2005-01-28 14:55:58 error: cast the timestam expression
Previous Message Swati Gadre 2005-01-28 13:49:06 calling JAVA UDF through trigger