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

What is dbrm? What it contains?

How Plan is created while executing the query using SPUFI?

What is runstats db2?

Compare a subselect to a join?

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

Which transaction use a command thread ?

What is declare cursor?

What are catalog tables in db2?

What is the difference between spufi and qmf?

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

what is dynamic cursor?gives syntax for this?

what is static sql? what is dynamic sql? Give me details

For more DB2 Interview Questions Click Here