How can u convert the Date to String?
- 6 Answers
- 15422 Views
- Microsoft, TCS, I also Faced
- E-Mail Answers
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 difference between views and tables?
What is a with(nolock)?
How to sort the query output with order by clauses in ms sql server?
How to change the name of a database user?
Explain different types of Normalization.
Is mysql the same as sql server?
Will the writetext statement activate a trigger?
What is rtm version in sql server?
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
What is executereader?
What are the new data types are introduced in sql 2000?
If no size is defined while creating the database, what size will the database have?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
How many partitions a clustered index has by default in sql server 2012?
What are the main sources of data?
