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

Which type of cursor is used to execute the dml statement?

896

Which query operators in sql is used for pattern matching?

904

What are the types of views in sql?

1041

How do I partition a table in sql?

1045

How sql query is executed?

1069

Explain what is a view?

998

explain the delete statements in sql

979

what is sub-query? : Transact sql

1043

How do I find duplicates in a single column in sql?

954

What do you understand by pl/sql cursors?

1020

How to prepare for oracle pl sql certification?

1012

What is sql stand for?

947

What are all types of user defined functions?

1006

Why plvtab is considered as the easiest way to access the pl/sql table?

1132

What is dialect in sql?

890