try this out select to_char(sysdate,' Day "," DDsp"th

what is the difference between to_char and to_date
functions?

Question Posted / jacob

Answer Posted / jacob

try this out
select to_char(sysdate,' Day "," DDsp"th " Month Year') from
dual

this gives the day,date,month,year of the current date

Is This Answer Correct ?

43 Yes

15 No

Please Help Members By Posting Answers For Below Questions

What is microsoft t sql?

483

Explain isolation levels. : Transact sql

571

Can we join tables without foreign key?

515

What are pl/sql cursor exceptions?

562

Is sql a oracle?

517

what is sql profiler? : Sql dba

577

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

526

Why is the cursor important?

526

How can you fetch common records from two tables?

579

What has stored procedures in sql and how we can use it?

559

Is the primary key an index?

586

How to convert comma separated string to array in pl/sql?

587

What is the purpose of a sql?

518

What are the two virtual tables available at the time of database trigger execution?

623

What is pl sql commands?

548