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 are expressions?

1003

How does a covering index work?

953

Which software is used for pl sql programming?

982

What do you understand by pl/sql records?

1014

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1222

Is pl sql useful?

985

what is online transaction processing (oltp)? : Sql dba

992

how to include character strings in sql statements? : Sql dba

1063

What is sqlca in db2?

948

How do you use a while loop in pl sql?

1006

Why is pl sql needed?

927

What is set transaction?

1035

What is function and procedure in pl sql?

1037

how do you know the version of your mysql server? : Sql dba

1000

What is a string data type in sql?

1033