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

how will be date change into string

Question Posted / sudipta santra

Answer Posted / sudipta santra

Is This Answer Correct ?

6 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How do I write a cron which will run a sql query and mail the results to agroup?

981

How do I copy a table in sql?

989

What are types of joins?

966

What is rowid in sql?

988

what is heap table? : Sql dba

1106

How can you load microsoft excel data into oracle? : aql loader

1174

What are the advantages of pl sql?

1122

How can I get the number of records affected by a stored procedure?

1066

What is minus?

1003

what is auto increment? : Sql dba

1011

What is a temporal data type?

1053

Can you inner join the same table?

992

How do I enable sql encryption?

1035

Is sql a scripting language?

1018

What is the difference between inner join and left join?

989