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

Which is better join or subquery?

0 Answers  

What is case function?

0 Answers  

What is program debugging?

0 Answers  

What is the use of stored procedures?

0 Answers  

How can we debug in PL/SQL?

0 Answers  




What does where 1 1 mean in sql?

0 Answers  

What is sql*loader and what is it used for? : aql loader

0 Answers  

what does the t-sql command ident_current does? : Transact sql

0 Answers  

how to show all tables with 'mysql'? : Sql dba

0 Answers  

select 1,col1,col2 from table1. output?

5 Answers   Ramco,

What is procedure and function?

0 Answers  

What is the location of pre_defined_functions.

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories