How to set column name in 'values' command

grofaty · #1 (**permalink**) 09-12-07, 04:16

Hi,
executing command from DB2CMD:

Code:

C:\temp>DB2 VALUES (CURRENT DATE)

returns output:

Code:

1
----------
12.09.2007

How to specify name of column (alias) to return the following output:

Code:

MyDate
----------
12.09.2007

The command:
DB2 VALUES (CURRENT DATE) AS MYDATE
is not working? Any idea?

Thanks,
Grofaty

n_i · #2 (**permalink**) 09-12-07, 06:07

Code:

with t (mydate) as (values current date)
select * from t