Re: HH:MM if today, else Mon, DD in SQL?

decode(time_due, sysdate, to_char(time_due,'HH-MM'), to_char(time_due, 'DD'))
should be all.

Hth,

Sybrand Bakker, Oracle DBA

Otis Gospodnetic <otis_at_my-deja.com> wrote in message news:8ce9lr$gkb$1_at_nnrp1.deja.com...
> Hi,
>
> I have a table that has a column with dates.
> When I get rows from that table I would like to be able to show hours
> and minutes if the date happens to be the current date(i.e. today);
> otherwise I would like to display month and day.
>
> For example, say that I'm displaying something like a to-do list:
>
> task time due
> ----------------------
> meet Jackie 01:37
> wake up 09:56
> buy shoes April 10
> go to Jelsa April 01
> ...
>
> Is this doable in SQL without stored procedures and without post
> processing of result set (comparing retrieved dates with current date)?
>
> Thank you,
>
> Otis
> P.S.
> Hmm...looks like an SQL question....but I am running Oracle 8.1.5.0.2
> on Linux actually :)
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Received on Wed Apr 05 2000 - 00:08:50 CDT