how will be date change into string

Answer Posted / sudipta santra

to_char(sysdate,'DD-MON-RRRR HH24:MI:SS')

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What language is oracle sql developer?

507


What is a left inner join?

533


What is trigger and types?

559


What is dba in sql? : SQL DBA

528


How does a covering index work?

524






Can we create index on primary key?

522


How to load data with sql*loader?

547


What is primary key secondary key alternate key candidate key?

540


What is trigger in flip flop?

512


Is sql a backend language?

616


Does sql backup shrink transaction log?

551


Does view contain data?

614


What are the different types of a subquery?

515


Explain foreign key in sql?

619


Is it possible to create startup or shutdown trigger for on-schema?

579