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

What is runstats db2?

583


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

626


What are union and union all?

539


What is image copy in db2?

570


Is db2 a mainframe?

586






What is the physical storage length of the data types date, time, and timestamp?

608


What are the benefits of using the db2 database?

660


What is db2 instance?

590


How do I copy a table in db2?

573


What is null indicator in cobol db2?

585


is it compulsory commitment control in journal?

2009


My sql statement select avg(salary) from emp yields inaccurate results. Why?

641


Is ibm db2 free?

573


What are the different types of base tables?

585


How many databases can be created inside an instance in db2 ?

599