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's the procedure?

865

Does sql backup shrink transaction log?

913

Explain the methods used to protect source code of pl/sql.

958

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

990

What is dbo in sql?

918

what is “go” in t-sql? : Transact sql

1039

what is top in tsql? : Transact sql

1022

Define join and name different types of joins?

957

What is the difference between row level and statement level trigger?

957

What is the use of prepared statement?

951

What are the advantages of sql? Explain

1050

List the various privileges that a user can grant to another user?

987

In what condition is it good to disable a trigger?

967

how many sql ddl commands are supported by 'mysql'? : Sql dba

955

How many types of relationship are there?

973