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 the format (internal layout) of ?TIMESTAMP??



What is the format (internal layout) of ?TIMESTAMP??..

Answer / s

yyyy mm dd hh mm ss nnnnnn
2 + 1 + 1 +1+ 1+ 1+ 3 = 10
Internal representation of TIMESTAMP is a string of 10
bytes. One byte for two packed decimal digits.

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More DB2 Interview Questions

What is referential integrity?

5 Answers  


What does db2 stand for?

0 Answers  


What is the physical storage length of timestamp data type?

0 Answers  


select distinct(empid),distinct(dept),name from EMP will the above query work?

2 Answers   CTS,


What is sqlcode -811?

7 Answers   Accenture, CTS, TCS,


If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?

2 Answers  


How do you retrieve the first 5 characters of firstname column of db2 table emp?

1 Answers  


What is Call attach facility? How does it work?

1 Answers   Syntel,


What is an asychronous write?

1 Answers  


Why use RUNSTAT Utility?

3 Answers   Merrill Lynch,


What kind of database is db2?

0 Answers  


What is an intent lock?

3 Answers  


Categories