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

What is a system versioned table?

0 Answers  

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

0 Answers  

what is self-join? : Sql dba

0 Answers  

What is rownum?

0 Answers  

What is normalization? dec 2009

3 Answers   Cognizant,




What is on delete restrict?

0 Answers  

what is cross join? : Sql dba

0 Answers  

If we declare constraints Unique and Not null on a single column then it will act as a Primary key, so what is the use of primary key??

3 Answers  

how to insert the data through views? The view is depending upon more than two tables? how to update materalized views?

3 Answers   3i Infotech,

Why stored procedures are faster than query?

0 Answers  

What is column?

0 Answers  

What does seeding a database mean?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories