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 the use of procedures?

1014

What is assignment operator in pl sql?

1086

Where is pl sql used?

1003

Is sql harder than python?

1157

what is the difference between cluster and non cluster index? : Sql dba

1077

What are joins in sql?

1108

What are the two types of periodical indexes?

987

What is the purpose of using pl/sql?

1189

What are the types pl/sql code blocks?

1195

What is denormalization in a database?

1105

How can you view the errors encountered in a trigger?

1022

What are the different sql languages?

1091

Is sql between inclusive?

1196

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1132

What is data types in sql?

1070