iN PL/SQL WE USE TO_CHAR FUNCTION SELECT TO

How can u convert the Date to String?

Question Posted / anil singh

Answer Posted / anil singh

iN PL/SQL WE USE TO_CHAR FUNCTION
SELECT TO_CHAR(SYSDATE,'MI','HH:MM:SS' FROM TABLE NAME

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to disable triggers using "disable trigger"?

1112

Comment,Datatypes are unlimited

2110

What is resultset concur_updatable?

1055

What is a non-clustered index?

1045

What is db stored procedure?

945

Difference between connected and disconnected database in .net with sql server?

1150

What is the purpose of linked server configuration in sql server?

1095

How many types of the database links?

1120

What is the difference between update lock and exclusive lock?

1028

Explain how many types of relationship?

1086

How to get a list of all tables with "sys.tables" view in ms sql server?

1085

How can we migrate from SQL server to SQL Azure?

113

What are the methods used to protect against sql injection attack?

1119

How to use order by with union operators in ms sql server?

1067

Does union all remove duplicates?

1123