1 as the select to_char (to_date (' 20161226 ', '- dd yyyy - mm'), 'day') from dual;

CodePudding user response:

1 the as take out, as the meaning behind the column name, can't add function

CodePudding user response:

Remove the tip is still the same

CodePudding user response:

I have no problem, the output is on Monday

CodePudding user response:

I am going to put into the column on Monday, 1 is the data

CodePudding user response:

The column name is not available in the SQL query

CodePudding user response:

The query result is dynamic, column name is static

CodePudding user response:

SQL server can realize dynamic column name

CodePudding user response:

Thank prawn people!!!!!!!!!! OK

CodePudding user response:

How??????

CodePudding user response:

 1 id, select to_char (to_date (' 20161226 ', '- dd yyyy - mm'), 'day') as dtime from dual; 

This can be?