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 does myisamchk do? : Sql dba

1010

Which certification is best for sql?

981

Is id a reserved word in sql?

1141

What is the difference between drop and truncate commands?

1058

Explain clause in sql?

1027

how can I make a script that can be bi-language (supports english, german)? : Sql dba

1010

Explain the uses of control file.

1048

What is microsoft t sql?

942

What are the different operators available in sql?

1000

What is a function in oracle pl sql?

1035

what is the difference between blob and text? : Sql dba

1017

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1698

What is the difference between function and procedure in pl/sql?

1081

Is pl sql and postgresql same?

1123

Name some usages of database trigger?

1017