Current Date 2

[Kreiss]

In DB2 is there a way to return the current date only once. When I say.... Select current date from ???? it returns the current date for each record in the table. Is there a way only to get the current date once?

Thanks in advance,
Kacy

 

[gregsimpson]

Kreiss,

SYSIBM.SYSDUMMY1 has been set up specifically for this type of thing.

Use SYSIBM.SYSDUMMY1 as the table your selecting from and you'll only get 1 row.

Cheers
Greg

 

[Kreiss]

Thanks Greg!
Exactly what I was looking for.

Kacy

 

[zeat]

Hi Kacy,

you need something like this:

SELECT CURRENT DATE
FROM SYSIBM.SYSDUMMY1;

You may also find this useful...

SELECT CURRENT DATE - (DAY (CURRENT DATE)) DAYS

gives you the last day of the previous month.

The first day of this month is
CURRENT DATE - (DAY(CURRENT DATE) - 1) DAYS


the last day of this month is
(CURRENT DATE + 1 MONTH ) - (DAY(CURRENT DATE + 1 MONTH)) DAYS


and the last day of this year is
CURRENT DATE + (12 - MONTH(CURRENT DATE)) MONTHS
+ (31 - DAY(CURRENT DATE)) DAYS


Cheers
Zeat

 

[sathyarams]

For a single row resultset, you can also use

VALUES(CURRENT DATE)

Cheers
Sathyarma


For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8