On Thursday, November 11, 2021, aditya desai <admad123(at)gmail(dot)com> wrote:
>
> " 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?
>
Dynamic SQL and two independent queries. One to get the column name. Then
a dynamic one (say using pl/pgsql) that uses that name.
David J.