View previous topic :: View next topic
|
Author |
Message |
superk
Global Moderator
Joined: 26 Apr 2004 Posts: 4652 Location: Raleigh, NC, USA
|
|
|
|
Would someone mind enlightening me a bit about what exactly a Timestamp is and what is its relevance? I see a lot of topics that mention it, so I'd like to have some sort of frame of reference. |
|
Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Kevin- do you really mean to ask that question? I scratch my head...
Timestap, read it as time-stamp...in general, a timestamp is a seven-part value (year, month, day, hour, minute, second, and microsecond) that represents a date and time as defined previously, except that the time includes a fractional specification of microseconds - however, this definition works well on IBM machines but in C timestamp macro is formatted as: ddd mmm dd hh:mm:ss yyyy.
|
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Peter,
Good link, and it also amused me a smidge.
...............Would you trust an organisation - International Organisation for Standardisation that calls itself ISO. |
|
Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
Well expat, only if members of that organization say to me :
"oh, ISO horney!" |
|
Back to top |
|
|
superk
Global Moderator
Joined: 26 Apr 2004 Posts: 4652 Location: Raleigh, NC, USA
|
|
|
|
Anuj Dhawan wrote: |
Kevin- do you really mean to ask that question? I scratch my head... |
Yes, I do. I'm not a developer or a DBA and I don't deal directly with business data structures much anymore. When I see a term pop up over and over again I like to make sure I understand not only what it means but also how it should be used in context. I only know how I understand the term from working with Oracle databases as a field format definition. You know as well as I do how many times posters misuse proper terminology. |
|
Back to top |
|
|
MBabu
Active User
Joined: 03 Aug 2008 Posts: 400 Location: Mumbai
|
|
|
|
As far as I know, its nothing more than an indicator of when something happened. What that indicator is used for is outside the scope of the definition. |
|
Back to top |
|
|
|