What is query for your birthday date should be in hours,minute
and seconds format?



What is query for your birthday date should be in hours,minute and seconds format?..

Answer / saikishore

select TIMESTAMP(DATECOLUMN)
FROM TABLE1

Is This Answer Correct ?    3 Yes 2 No

Post New Answer

More DB2 Interview Questions

What is meant by dclgen?

0 Answers  


Is it mandatory to use DCLGEN? If not, why would you use it at all?

2 Answers  


What is db2 catalog database?

0 Answers  


Can any one tell me about Restart logic in DB2.

2 Answers  


How can the firstname and the lastname from the emp table be concatenated to generate complete names?

0 Answers  






What is sqlcode -922 ?

2 Answers  


when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic

2 Answers   TCS,


What do you mean by rollback?

0 Answers  


What are the full forms of spufi and dclgen and why are they used?

0 Answers  


What is a subselect? Is it different from a nested select?

1 Answers  


What is an access path?

3 Answers  


Is there any advantage to denormalizing DB2 tables?

1 Answers  


Categories