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

How is indexing done in search engines?

987

What is the use of <> sql?

986

How do I start sql from command line?

1029

What is clustered and nonclustered index in sql?

951

Why do we need cursor in pl sql?

1142

If a cursor is open, how can we find in a pl/sql block?

1175

Which is better join or subquery?

1151

What is graph sql?

998

How to write pl sql program in mysql command prompt?

1105

What are the topics in pl sql?

985

How to rename a column in the output of sql query?

1078

Why do we need a foreign key?

1110

What do we need to check in database testing?

1030

What are the query optimization techniques?

944

explain the difference between myisam static and myisam dynamic. : Sql dba

956