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

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

Question Posted / jabir

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

More DB2 Interview Questions

How do I add a column to an existing table in db2?

What is host variable?

What is dynamic SQL?

how to copy the host variables from ps file into cobol program other than include statement

How to define the data items to receive the fetch items for the SQL?

Explain correlated sub-queries.

What is IMAGECOPY ?

What is a db2 cursor?

How will you delete duplicate records from a table?

can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

What is ibm db2 used for?

What techniques will be used to avoid deadlock??

For more DB2 Interview Questions Click Here