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 an intent lock?

3 Answers  


what's the error code for Unique Index Violation?

2 Answers  


I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!

17 Answers   KNIT, Tech Mahindra,


Can I use LOCK TABLE on a view?

1 Answers  


Mention the length of physical storage of the given data types of db2 – date, timestamp, time

0 Answers  


What is precompiler in db2?

0 Answers  


How does DB2 determine what lock-size to use?

2 Answers  


in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?

1 Answers   IBM,


What is ibm db2 used for?

0 Answers  


wht steps we need will coding cobol and db2 pgm ?

6 Answers   CGI,


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

0 Answers  


Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?

2 Answers   Verizon,


Categories