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 stop a loop early with break statements in ms sql server?

1020

What is full outer join in sql server joins?

1068

What is the filtered index?

1058

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

976

Is the order of columns in the set clause important in ms sql server?

970

How to create a new schema in a database?

1151

What is a view in sql?

977

Differentiate between a primary key and a unique key.

1073

what are the different ways to return the rowcount of a table?

1001

What is user-defined function?

979

what is a self join? Explain it with an example? : Sql server database administration

953

Explain the types of indexes.

1218

how would you troubleshoot blocking? : Sql server database administration

983

What are the differences between lost updates and uncommitted dependencies?

1080

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

3873