to_char(sysdate,'DD-MON-RRRR HH24:MI:SS')

how will be date change into string

Question Posted / sudipta santra

Answer Posted / sudipta santra

Is This Answer Correct ?

6 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the difference between count 1 and count (*) in a sql query?

1049

How can check sql version from command line?

1129

Can we use views in stored procedure?

1082

Can we edit a view in sql?

1038

What is case function?

1087

What is native sql query?

1072

What is a sql select statement?

1080

What are different types of tables in sql?

1045

What is sql dialect?

1170

Why function is used in sql?

989

What is sql stand for?

1031

What is a unique key and primary key and foreign key?

1020

What is clustered and nonclustered index in sql?

983

Can there be more than one function with a similar name in a pl/sql block?

1036

Is sql a dbms?

1058