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 do you know by pl/sql cursors?

1107

What is a constraint?

1027

Can there be 2 primary keys in a table?

997

Is pl sql a programming language?

994

What is data definition language?

1097

Is left join inner or outer by default?

1024

What does select * from mean in sql?

3243

What is field delimiter?

1048

i have some prob lem to tell me about my self in interview first round ...

2166

Are stored procedures faster than queries?

948

how to see the create table statement of an existing table? : Sql dba

1019

How does sql profiler work?

1023

How many parts of a pl sql block are optional?

1137

Can we insert in view in sql?

1065

How to change sql*plus system settings?

1059