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
On 08/15/2010 03:07 PM, Paul Gilmartin wrote: 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

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

Re: Date formats

2010-08-13 Thread Veilleux, Jon L
You forgot SMF time: number of hundredths of seconds since midnight. Jon L. Veilleux veilleu...@aetna.com (860) 636-9179 -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of zMan Sent: Friday, August 13, 2010 12:25 PM To:

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
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. -- John McKown Systems Engineer IV IT Administrative Services Group HealthMarkets®

Re: Date formats

2010-08-13 Thread Field, Alan C.
Having grown up using dd/mm/yy then having to switch to mm/dd/yy so I don't know whether my birthday is 09/06 or 06/09 I'm partial to a ddmmmyy format where mmm is JAN, FEB, ... DEC Alan -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of

Re: Date formats

2010-08-13 Thread Mike Schwab
The International Astronomical Union uses the Julian Date / Time format. 0 was at January 1, 4713 BCE Greenwich noon, increments by 1 per day, decimal fraction of day for time. http://en.wikipedia.org/wiki/Julian_day Various Gregorian calendar formats, including a list by country.

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
Years ago, Dr Merrill stated that MXG probably processed more different date and time formats than any other software package. If you have access to it, it may provide a good starting point. -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf

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
Formats are of interest for displaying|printing dates. They are of almost no interest for storing dates, which should be stored as signed integers that specify day counts before and after some epoch origin, giving each day a serial number in the sequence . . . , -2, -1, 0, +1, +2, . . .

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
john gilmore wrote: Formats are of interest for displaying|printing dates. They are of almost no interest for storing dates, which should be stored as signed integers that specify day counts before and after some epoch origin, giving each day a serial number in the sequence Oh my! Should

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 the

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