select to_char(sysdate,'ddsp')||'-'||to

how will be date change into string

Question Posted / rajgopal

Answer Posted / rajgopal

select to_char(sysdate,'ddsp')||'-'||to_char(sysdate,'mon')||'-'||to_char(sysdate,'yyyysp') from dual

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is difference between mysql and postgresql?

1162

Is sql port 1433 encrypted?

1031

What does t sql mean?

951

What is clause?

1158

Why use subqueries instead of joins?

1083

How do you get column names only for a table (sql server)?

1170

How does a self join work?

1133

What is sqlite used for?

1008

What is sqlcontext?

1090

How do you bind variables in pl sql?

1104

What is a left inner join?

1022

How can you view the errors encountered in a trigger?

966

What are the different operators available in sql?

1008

how to decrement dates by 1 in mysql? : Sql dba

1023

Why truncate is faster than delete?

1119