Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

how will be date change into string

Question Posted / abhishek.singh1880

Answers were Sorted based on User's Feedback



how will be date change into string..

Answer / sudipta santra

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

Is This Answer Correct ?    6 Yes 1 No

how will be date change into string..

Answer / rajgopal

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

Is This Answer Correct ?    2 Yes 0 No

how will be date change into string..

Answer / r98

select to_char(sysdate,'ddsp-month-yyyysp') from dual;

Is This Answer Correct ?    1 Yes 0 No

how will be date change into string..

Answer / yogesh

Rajagopal answer is correct.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Is sql a dbms?

0 Answers  

wirte a query to filter improper date format follwing table? date 20-apr 22-may-2010 26-jun-2010 feb-2009 i want the output date 22-may-2010 26-jun-2010

6 Answers   Accenture,

What is trigger explain with example?

0 Answers  

A table has 150 records. How do you retrieve 100th row to 120th row from that table ?

21 Answers   IBM,

What do you mean by rowid?

0 Answers  




Can you have more than one trigger on a table?

0 Answers  

Can we insert data into materialized view?

0 Answers  

What is a trigger in sql?

0 Answers  

What is a trigger ?

11 Answers   Accenture, BirlaSoft,

What is the difference between delete and truncate statement in sql?

0 Answers  

What is correlated sub-query?

7 Answers   Oracle,

Mention what problem one might face while writing log information to a data-base table in pl/sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories