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
What is runstats and reorg in db2?
Explain in brief how does db2 determine what lock-size to use?
How do I add a column in db2?
What do you mean by cursor?
Can you tell me how can you find out the # of rows updated after an update statement?
How can we retrieve the total number of records in RPG & CLLE?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is the maximum length of sqlca?
What is database manager in db2?
What is bind and rebind in db2?
What are union and union all?
What is the purpose of using commit?
Define buffer pool.
What is access path in db2?
What is host variable?