how to select all with to_char function in sql statement

Question

the code below is my sqlcommand for select statement. Inside have a lots of data including two date data inside.

string sql = "SELECT * FROM TASKMASTER WHERE TASKNAME ='" + TaskName + "'";

can I add in ('DD-MM-YYYY HH24:MI:SS')AS CREATEDATE into the sqlcommand and at the same time will call out all the column in the table?

Lalit Kumar B · Accepted Answer · 2015-06-08 07:21:51Z

4

You could use a table alias.

For example,

SELECT TO_CHAR(t.dt_column, 'DD-MM-YYYY HH24:MI:SS') as CREATEDATE, 
       t.* 
FROM TASKMASTER t 
WHERE t.TASKNAME = '" + TaskName + "'"

So, you added your desired column in the beginning of the column list, and also selecting all other columns followed by it.

answered Jun 8, 2015 at 7:21

Lalit Kumar B

49.5k13 gold badges104 silver badges131 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1