IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

What exactly is a Timestamp? Why is it relevant?


IBM Mainframe Forums -> All Other Mainframe Topics
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
superk

Global Moderator


Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA

PostPosted: Fri Jan 15, 2010 6:43 pm
Reply with quote

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
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen

PostPosted: Fri Jan 15, 2010 6:45 pm
Reply with quote

en.wikipedia.org/wiki/ISO_8601
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Fri Jan 15, 2010 6:57 pm
Reply with quote

Kevin- do you really mean to ask that question? I scratch my head... icon_neutral.gif

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
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Fri Jan 15, 2010 7:06 pm
Reply with quote

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
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen

PostPosted: Fri Jan 15, 2010 7:23 pm
Reply with quote

Well expat, only if members of that organization say to me :


"oh, ISO horney!"
Back to top
View user's profile Send private message
superk

Global Moderator


Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA

PostPosted: Fri Jan 15, 2010 9:17 pm
Reply with quote

Anuj Dhawan wrote:
Kevin- do you really mean to ask that question? I scratch my head... icon_neutral.gif


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
View user's profile Send private message
MBabu

Active User


Joined: 03 Aug 2008
Posts: 400
Location: Mumbai

PostPosted: Sat Jan 16, 2010 3:12 am
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> All Other Mainframe Topics

 


Similar Topics
Topic Forum Replies
No new posts To get the count of rows for every 1 ... DB2 3
No new posts Insert system time/date (timestamp) u... DFSORT/ICETOOL 5
No new posts Timestamp difference and its average ... DB2 11
No new posts To get previous month from current ti... SYNCSORT 7
No new posts Calculate with timestamp PL/I & Assembler 19
Search our Forums:

Back to Top