Hi,
I want to construct column name alias by using different queries. E.g.
below.
postgres=# Select ('Status as on '||date_part('day', (SELECT
current_timestamp))||'th '||TO_CHAR(current_timestamp, 'Mon'))
postgres-# ;
?column?
-----------------------
Status as on 11th Nov
" Status as on 11th Nov" should be my column name in a query.
SELECT JoiningDate as "Status as on 11th Nov" from empdetails;
How can I achieve this?
Regards,
Aditya.