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

Answer Posted / saikishore

select TIMESTAMP(DATECOLUMN)
FROM TABLE1

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When do you specify the isolation level?

781


How do you find the maximum value in a column in db2?

818


What is bufferpool in db2?

789


Why db2 is called db2?

758


Which are the db2 tools to protect integrity of the database?

877


What is a collection in db2?

750


Why do chiropractors use drop table?

854


What is nvl in db2?

803


How is a typical db2 batch pgm executed?

834


What is ibm db2 used for?

807


Define buffer pool.

789


How can we read records for specific member in CL? AND rpg?

426


Define sqlca.

834


What is role in db2?

767


Explain about open switch business continuity software?

805