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

Can one database have multiple instances?

List down the data types in the db2 database.

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 the use of commit in db2?

Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?

Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?

How are write I/Os from the buffer pool executed?

Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.

What is the difference between plan and package in db2?

What is declare cursor?

What is bind and rebind in db2?

What is db2 purescale?

For more DB2 Interview Questions Click Here