1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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

Post New Answer

More DB2 Interview Questions

What does the RUNSTATS Utility do?

4 Answers  

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

0 Answers  

How to resolve -803 sql code in DB2?

3 Answers   Cap Gemini,

What techniques are used to retrieve data from more than one table in a single SQL statement?

2 Answers  

List down the data types in the db2 database.

0 Answers  




If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

0 Answers  

How to retrieve rows from a db2 table in embedded sql?

0 Answers  

How to get the ddl of a table in db2?

0 Answers  

What is a db2 cursor?

0 Answers  

how can we find nth max salary from A table

5 Answers   IBM,

How can you find out the # of rows updated after an update statement?

0 Answers  

explain about index with examples

2 Answers   Syntel,

For more DB2 Interview Questions Click Here
Categories