DATE SQL

From: "wanpeng" <wanp2005(at)gmail(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: DATE SQL
Date: 2006-03-06 10:39:09
Message-ID: 01ec01c6410a$36814e00$4d06050a@WANP
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I want a result like

'2006-03-01'
'2006-03-02'
'2006-03-03'
'2006-03-04'

FROM table xxx

……| start_date | end_date |……
| '2006-03-01' | '2006-03-04'|

how can I write the sql

thanks

-----------------------------------------------
wanp2005(at)gmail(dot)com

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2006-03-06 12:55:15 Re: JDBC support for 8.1 OUT parameters
Previous Message John R Pierce 2006-03-06 06:20:29 Re: how to connect remotely?