select to_char(sysdate,'ddsp')||'-'||to

how will be date change into string

Question Posted / rajgopal

Answer Posted / rajgopal

select to_char(sysdate,'ddsp')||'-'||to_char(sysdate,'mon')||'-'||to_char(sysdate,'yyyysp') from dual

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can we insert in sql function?

774

How do you modify a table in sql?

802

Can we create a trigger on view?

668

How subquery works in sql?

727

Why left join is used in sql?

705

What is sql and how does it work?

739

What is an example of translating a date into julian format?

777

Is sql better than excel?

701

What is the difference between database trigger and stored procedure?

740

Explain clause in sql?

748

what is log shipping? : Sql dba

822

Which join is like an inner join?

720

What is pl sql and why it is used for?

799

Can we rollback after truncate?

754

what are the join types in tsql? : Transact sql

755