Re: SQL Puzzle

From: Claus L. Rasmussen <claus_at_oodac.dk>
Date: Wed, 01 Dec 1999 14:21:53 +0100
Message-ID: <384520F1.F65EA6F9@oodac.dk>

NetComrade wrote:
>
> Hi I have the table with the following records
>
> SQLWKS> SELECT TO_CHAR(price, '$99,999,999') , TO_CHAR(when_closed,
> 'MM/DD')
> 2> FROM player_close
> 3> WHERE player_id = 1002
> 4> AND when_closed >= SYSDATE - 14
> 5>
> TO_CHAR(PRIC TO_CHAR(WHEN_CLOSED,'MM/DD')
>
> $12,080,000 11/17

[...]

> $12,590,000 11/30
>
> 10 rows selected.
>
> but the output I would like is
>
> $12,080,000 11/18

[...]

> $12,590,000 sysdate
>
> basically moving up the date.
>
> Any suggestions?

Just add one to <when_closed>. Ex.

SQL> select sysdate from dual;

SYSDATE

---

01-DEC-99 SQL> select sysdate + 1 from dual;

SYSDATE

---

02-DEC-99 Received on Wed Dec 01 1999 - 07:21:53 CST