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
List out a number of the wants to setup a SQL Server failover cluster?
What is check constraint in sql server?
Explain how many normalization forms?
Do you know what are the restrictions that views have to follow?
Explain what are commit and rollback in sql?
What the difference between UNION and UNIONALL?
What happens if you insert a duplicate key for the primary key column in ms sql server?
Explain differences between web edition and business edition?
What is order of B+tree?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
How to apply filtering criteria at group level with the having clause in ms sql server?
How to create a new schema in a database?
Define right outer join?
Explain the difference between primary keys and foreign keys?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?