Re: [Fwd: Re: date formats]

2010-08-16 Thread Shmuel Metz (Seymour J.)
In 1281901727.14657.141.ca...@mckown5.johnmckown.net, on 08/15/2010 at 02:48 PM, John McKown joa...@swbell.net said: Believe it or not, our 20xx dates are encoded x'9A001' for 2000, Which would imply that you had to track down every program that did arithmetic on dates. -- Shmuel

Re: [Fwd: Re: date formats]

2010-08-16 Thread McKown, John
-Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Shmuel Metz (Seymour J.) Sent: Monday, August 16, 2010 4:56 AM To: IBM-MAIN@bama.ua.edu Subject: Re: [Fwd: Re: date formats] In 1281901727.14657.141.ca...@mckown5.johnmckown.net

Re: date formats

2010-08-16 Thread Paul Gilmartin
On Sun, 15 Aug 2010 20:01:49 -0500, Joel C. Ewing wrote: The point of Shmuel's comment, of course, is that the one most common, unavoidable-in-MVS place where dates of the form yyddd were in wide-scale use was in SMF accounting records. The format there is packed-decimal, so hex digits are out.

Re: Date formats

2010-08-16 Thread Lloyd Fuller
zMan wrote: On Fri, Aug 13, 2010 at 12:29 PM, Brian Kennelly brian+ibm-m...@bkennelly.net wrote, re days so far in the year as a date format: That is actually a very import format, as well as the full format returned by the TIME macro: 0cyyddd. (Century, year, days in year.) Sure, days this

Re: Date formats

2010-08-15 Thread Shmuel Metz (Seymour J.)
In aanlktinywtvwhvqwd8ogoog2kkotyyis40s9taxbj...@mail.gmail.com, on 08/13/2010 at 12:25 PM, zMan zedgarhoo...@gmail.com said: How many different date formats are there? How many would you like? Are you only concerned with the Gregorian calendar? There's the hardware timestamp, With your

Re: date formats

2010-08-15 Thread Shmuel Metz (Seymour J.)
In listserv%201008131709378676.0...@bama.ua.edu, on 08/13/2010 at 05:09 PM, Paul Gilmartin paulgboul...@aim.com said: I'll agree enthusiastically except where the change could be made in a compatible manner, altering no sizes, displacements, nor content of existing data bases. One example

Re: date formats

2010-08-15 Thread John McKown
On Sun, 2010-08-15 at 08:23 -0400, Shmuel Metz (Seymour J.) wrote: In listserv%201008131709378676.0...@bama.ua.edu, on 08/13/2010 at 05:09 PM, Paul Gilmartin paulgboul...@aim.com said: I'll agree enthusiastically except where the change could be made in a compatible manner, altering no

[Fwd: Re: date formats]

2010-08-15 Thread John McKown
Forwarded Message From: John McKown joa...@swbell.net Subject: Re: date formats Date: Sun, 15 Aug 2010 13:27:39 -0500 On Sun, 2010-08-15 at 08:23 -0400, Shmuel Metz (Seymour J.) wrote: In listserv%201008131709378676.0...@bama.ua.edu, on 08/13/2010 at 05:09 PM, Paul

Re: date formats

2010-08-15 Thread Paul Gilmartin
On Sun, 15 Aug 2010 08:23:18 -0400, Shmuel Metz (Seymour J.) wrote: In listserv%201008131709378676.0...@bama.ua.edu, on 08/13/2010 at 05:09 PM, Paul Gilmartin said: I'll agree enthusiastically except where the change could be made in a compatible manner, altering no sizes, displacements, nor

Re: [Fwd: Re: date formats]

2010-08-15 Thread Mike Schwab
On Sun, Aug 15, 2010 at 2:48 PM, John McKown joa...@swbell.net wrote: Believe it or not, our 20xx dates are encoded x'9A001' for 2000, and so on up the alphabet. I wasn't in on this, so I don't know where it terminates. But x'9F' is the max - 2015. So the world better end in 2012! grin x'90'

Re: date formats

2010-08-15 Thread Joel C. Ewing
of what date formats should be supported by a conversion routine has a different answer if the object is to support a single installation rather than for a general purpose vendor utility. It makes sense that local installation standards should try to minimize the number of different date

Re: Date formats

2010-08-14 Thread Bruce Richardson
What about NETTIME used by NTP (and friends). -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at

Date formats

2010-08-13 Thread zMan
How many different date formats are there? There's the hardware timestamp, in two forms (original, with the 2046 rollover, and the extended one -- what is that, a STCKE instruction?). There's something called an Oracle format date. There's some UNIX format that rolls over in 2034 or some such (tsk

Re: Date formats

2010-08-13 Thread Veilleux, Jon L
@bama.ua.edu Subject: Date formats How many different date formats are there? There's the hardware timestamp, in two forms (original, with the 2046 rollover, and the extended one -- what is that, a STCKE instruction?). There's something called an Oracle format date. There's some UNIX format that rolls

Re: Date formats

2010-08-13 Thread Brian Kennelly
On Fri, Aug 13, 2010 at 09:25, zMan zedgarhoo...@gmail.com wrote: Rexx has a few others, but they're conveniences, like the number of days this year -- I don't really consider that a date format, though it's useful sometimes. That is actually a very import format, as well as the full format

Re: Date formats

2010-08-13 Thread McKown, John
and The MEGA Life and Health Insurance Company.SM -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of zMan Sent: Friday, August 13, 2010 11:25 AM To: IBM-MAIN@bama.ua.edu Subject: Date formats How many different date formats

Re: Date formats

2010-08-13 Thread Field, Alan C.
Of zMan Sent: Friday, August 13, 2010 11:25 To: IBM-MAIN@bama.ua.edu Subject: Date formats How many different date formats are there? There's the hardware timestamp, in two forms (original, with the 2046 rollover, and the extended one -- what is that, a STCKE instruction?). There's something called

Re: Date formats

2010-08-13 Thread Mike Schwab
Company.SM -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of zMan Sent: Friday, August 13, 2010 11:25 AM To: IBM-MAIN@bama.ua.edu Subject: Date formats How many different date formats are there? There's the hardware timestamp, in two

Re: Date formats

2010-08-13 Thread zMan
On Fri, Aug 13, 2010 at 12:29 PM, Brian Kennelly brian+ibm-m...@bkennelly.net wrote, re days so far in the year as a date format: That is actually a very import format, as well as the full format returned by the TIME macro: 0cyyddd.  (Century, year, days in year.) Sure, days this year can be

Re: Date formats

2010-08-13 Thread zMan
On Fri, Aug 13, 2010 at 12:32 PM, McKown, John john.mck...@healthmarkets.com wrote: There are two that I know of which you did not mention. Lilian and COBOL. COBOL is an integer which is the number of days since 31Dec1600. Lilian is an integer which is the number of days since 14Oct1582. Wow,

Re: Date formats

2010-08-13 Thread Brian Kennelly
On Fri, Aug 13, 2010 at 10:42, zMan zedgarhoo...@gmail.com wrote: Sure, days this year can be useful, but does anyone store dates as days so far in the year? It's basically the Julian date without the year. Yes, they do. I worked on a data conversion product a few years ago for a software

Re: Date formats

2010-08-13 Thread Don Poitras
SAS uses lots of date formats. ISO 8601 is a good spot to look for a large list. http://support.sas.com/documentation/cdl/en/lrdict/63026/HTML/default/a003169814.htm http://en.wikipedia.org/wiki/ISO_8601 zMan wrote: How many different date formats are there? There's the hardware timestamp

Re: Date formats

2010-08-13 Thread Ted MacNEIL
SAS uses lots of date formats. ISO 8601 is a good spot to look for a large list. Now, you have to be careful about that statement! SAS displays a lot of formats. But, usually, there is only one internal format. Days from June 1, 1960, iirc. - I'm a SuperHero with neither powers, nor

Re: Date formats

2010-08-13 Thread Schwarz, Barry A
Of zMan Sent: Friday, August 13, 2010 9:25 AM To: IBM-MAIN@bama.ua.edu Subject: Date formats How many different date formats are there? There's the hardware timestamp, in two forms (original, with the 2046 rollover, and the extended one -- what is that, a STCKE instruction?). There's something

Re: Date formats

2010-08-13 Thread Ted MacNEIL
Years ago, Dr Merrill stated that MXG probably processed more different date and time formats than any other software package. MXG had that facilty mainly because SAS could do most of them. But, once read, they were stored in internal (SAS) format. Don't get me wrong. MXG is a great example of

Re: date formats

2010-08-13 Thread john gilmore
of the Julian astronomical calendar. Storing multiple date formats is a mug's game. It brings the need for too many conversion routines in train. The canonical reference for all calendrical calculations, which I have mentioned on IBM-MAIN before, is Nachum Dershowitz Edward M. Reingold

Re: Date formats

2010-08-13 Thread Paul Gilmartin
On Fri, 13 Aug 2010 12:25:01 -0400, zMan wrote: How many different date formats are there? There's the hardware timestamp, in two forms (original, with the 2046 rollover, and the extended one -- what is that, a STCKE instruction?). There's something ETOD ends at the same point as TOD, despite

Re: date formats

2010-08-13 Thread Paul Gilmartin
On Fri, 13 Aug 2010 18:48:55 +, john gilmore wrote: The obvious epoch origin to use is that for CE and BCE dates, viz., December 31 of the Gregorian calendar. Other epoch origins can then be supported simply using a table of displacements. That would be a proleptic Gregorian

Re: date formats

2010-08-13 Thread Steve Comstock
. Storing multiple date formats is a mug's game. It brings the need for too many conversion routines in train. The canonical reference for all calendrical calculations, which I have mentioned on IBM-MAIN before, is Nachum Dershowitz Edward M. Reingold. Calendrical computations. Cambridge

Re: Date formats

2010-08-13 Thread Steve Comstock
Don Poitras wrote: SAS uses lots of date formats. ISO 8601 is a good spot to look for a large list. http://support.sas.com/documentation/cdl/en/lrdict/63026/HTML/default/a003169814.htm http://en.wikipedia.org/wiki/ISO_8601 zMan wrote: How many different date formats are there? There's

Re: date formats

2010-08-13 Thread john gilmore
Paul Gilmartin wrote: | That would be a proleptic Gregorian date? and the answer to his question is that the dates of all days that occur before a calendar's epoch origin are proleptic for that calendar by definition. Their day numbers are negative. The use of a fullword for Gregorian day

Re: date formats

2010-08-13 Thread Paul Gilmartin
On Fri, 13 Aug 2010 21:49:19 +, john gilmore wrote: | That would be a proleptic Gregorian date? and the answer to his question is that the dates of all days that occur before a calendar's epoch origin are proleptic for that calendar by definition. Their day numbers are negative. The

Re: Date formats

2010-08-13 Thread Joel C. Ewing
On 08/13/2010 12:43 PM, zMan wrote: On Fri, Aug 13, 2010 at 12:32 PM, McKown, John john.mck...@healthmarkets.com wrote: There are two that I know of which you did not mention. Lilian and COBOL. COBOL is an integer which is the number of days since 31Dec1600. Lilian is an integer which is

Re: date formats

2010-08-13 Thread Mike Schwab
On Fri, Aug 13, 2010 at 5:09 PM, Paul Gilmartin paulgboul...@aim.com wrote: deleted I was more thinking of 1582.  Wikipedia (which is always right except when it disagrees with you) says:    http://en.wikipedia.org/wiki/Proleptic_Gregorian_calendar    The proleptic Gregorian calendar is

FW: Date formats

2010-08-13 Thread William M Klein
See below From: William M Klein [mailto:wmkl...@ix.netcom.com] Sent: Friday, August 13, 2010 10:25 PM To: William M. Klein Subject: Date formats On 08/13/2010 12:43 PM, zMan wrote: On Fri, Aug 13, 2010 at 12:32 PM, McKown, John john.mck...@healthmarkets.com wrote: There are two that I