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 are system databases into sql server (2005/2008)?

592


what is the sql equivaent of the dataset relation object ?

1573


When to use Inner join & when to use subquery?

581


Why use view instead of a table?

528


Explain Geography datatype in SQL Server

633






What is the difference between NOROW and LOCKROW?

2244


What are different types of schemas?

523


What are group functions in query statements in ms sql server?

557


What are the events recorded in a transaction log?

508


How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

556


explain the storage models of olap? : Sql server database administration

524


System requirements for sql server 2005 express edition?

571


How can we remove orphan records from a table?

529


What is the xml datatype?

630


What is indexing a document?

559