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

How do you clear the screen in sql?

1054

Does sql full backup truncate logs?

1007

What is a composite primary key?

1071

What is pl/sql table? Why is it used?

1014

what is datawarehouse? : Sql dba

999

Can a select statement fire a trigger?

1141

Is it possible to include an insert statement on the same table to which the trigger is assigned?

1000

What are the parts of a basic sql query?

956

What is pragma in pl sql?

1087

What is form and report?

961

What is the largest value that can be stored in a byte data field?

1001

Write a sql query to convert all character to uppercase after hypen.

1416

How does left join work in sql?

985

What is string data type in sql?

1116

how to enter characters as hex numbers? : Sql dba

1025