How can u convert the Date to String?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the meaning of lock escalation and why/how to stop this? : sql server database administration

699


What is a unique index?

605


What is the difference between seek predicate and predicate?

665


What happens if null values are involved in boolean operations?

638


What is logshipping and its purpose?

636






What does REVERT do in SQL Server 2005?

627


What happens if null values are involved in string operations?

642


How to find Duplicate Records In table?

666


what are the different types of replication you can set up in sql server? : Sql server database administration

613


How many types of attribute relationships are there? : sql server analysis services, ssas

674


Explain nested join?

647


What is the maximum row of a size?

655


Give me a SQL Query to find out the second largest company?

801


How to delete all rows with truncate table statement in ms sql server?

577


What is 2nf normalization form?

703