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's the Maximum Length of SQLCA and what's the content of SQLCABC?

what are stage one indexable predicates?

what is difference between Plan and Package

What is a recovery log?

Are views updateable?

What is a system catalog table in db2?

What is the use of db2 optimizer?

What is auditing?

What is DCLGEN ?

What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?

What db2 400?

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

For more DB2 Interview Questions Click Here