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 is the meaning of lock escalation and why/how to stop this? : sql server database administration
What is a unique index?
What is the difference between seek predicate and predicate?
What happens if null values are involved in boolean operations?
What is logshipping and its purpose?
What does REVERT do in SQL Server 2005?
What happens if null values are involved in string operations?
How to find Duplicate Records In table?
what are the different types of replication you can set up in sql server? : Sql server database administration
How many types of attribute relationships are there? : sql server analysis services, ssas
Explain nested join?
What is the maximum row of a size?
Give me a SQL Query to find out the second largest company?
How to delete all rows with truncate table statement in ms sql server?
What is 2nf normalization form?