Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


What is query for your birthday date should be in hours,minute
and seconds format?



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 happens to a cursor after a commit?

3 Answers  


What is meant by index cardinality?

2 Answers  


What is iseries database?

0 Answers  


What is sqlcode -811?

7 Answers   Accenture, CTS, TCS,


what is the difference between where clause and having clause

2 Answers   IBM,


This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.

3 Answers  


i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

4 Answers  


What is a predicate?

1 Answers  


What is read-only cursor?

1 Answers  


Why do we bind in db2?

0 Answers  


Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq

2 Answers  


What is the use of predicate?

0 Answers  


Categories