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
What are system databases into sql server (2005/2008)?
what is the sql equivaent of the dataset relation object ?
When to use Inner join & when to use subquery?
Why use view instead of a table?
Explain Geography datatype in SQL Server
What is the difference between NOROW and LOCKROW?
What are different types of schemas?
What are group functions in query statements in ms sql server?
What are the events recorded in a transaction log?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
explain the storage models of olap? : Sql server database administration
System requirements for sql server 2005 express edition?
How can we remove orphan records from a table?
What is the xml datatype?
What is indexing a document?