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 the advantage of index in sql?

1020

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

1021

What is sql rowcount?

1073

How can use stored procedures in sql?

1193

What is a Mapplet?

1200

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1250

What is pl sql architecture?

1006

Differentiate between sga and pga.

1208

Why stored procedure is better than query?

1003

how many columns can be used for creating index? : Sql dba

989

What is sql and its types?

1254

Explain mutating table error.

1263

What is tuple in sql?

1143

What is character functions?

1116

Explain how can you save or place your msg in a table?

1078