how will be date change into string

Answer Posted / r98

select to_char(sysdate,'ddsp-month-yyyysp') from dual;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you join a table to itself?

712


Is sql a oracle?

698


what are the performance and scalability characteristics of mysql? : Sql dba

723


What is the command used to fetch the first 5 characters of a string?

922


What is keys and its types?

748






What are the query optimization techniques?

711


How many columns should be in an index?

707


Is sqlexception checked or unchecked?

723


What are the types of optimization?

688


what is the difference between where clause and having clause? : Sql dba

723


what is the difference between cluster and non cluster index? : Sql dba

730


What are the possible values for the boolean data field?

689


What is pl/sql table? Why is it used?

734


What is a rank in sql?

714


What does sql stand for?

702