Re: Is there a name for date format used by DB2? -- MIDRANGE-L

Good News Everybody!

The new search engine is LIVE!

Please report any problems to david (at) midrange.com.

Subject: Re: Is there a name for date format used by DB2?
From: Justin Dearing <zippy1981@xxxxxxxxx>
Date: Fri, 16 Oct 2015 23:40:14 +0000
List-archive: <http://archive.midrange.com/midrange-l/>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/options/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

On Fri, Oct 16, 2015 at 6:28 PM Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
wrote:

Dates, times, and timestamps are stored the same way whether table/file
created DDS source or by a CREATE TABLE. The underlying objects and data
types are the same. That is what object-based system is all about.

An excellent point Vern. I was unclear. I want the name of the format of
the string, which is most definitely not ISO 8601, that I can pass to an
INSERT or UPDATE statement that will be parsed and converted into the 10
bytes that get stored in the physical file.

Justin

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.