Fwd: Re: Date different

Thread view:

steve - 22 Oct 2005 11:10 GMT

----- Begin Forwarded Message -----

Date: Thu, 20 Oct 2005 11:39:49 GMT
Subject: Re: Date different
From: Roedy Green <my_email_is_posted_on_my_website@munged.invalid>
Reply-To: Roedy Green <my_email_is_posted_on_my_website@munged.invalid>
Newsgroups: comp.lang.java.programmer

On Fri, 14 Oct 2005 06:20:28 +0800, steve <steve@aol.com> wrote or quoted :

>Their mapping of Date to Date, is just crass and lacks thought.
>it should be mapped not based on the name, but on the data it returns,
>not doing that results in loss of information.

Maybe the next layer of Chinese menu in JDBC will let you define your own
custom conversion functions both ways between Java classes and primitives and
what the database offers to help you get past goofy stuff like this.

Signature

Canadian Mind Products, Roedy Green.
http://mindprod.com Again taking new Java programming contracts.

----- End Forwarded Message -----

actually the sql timestamps are the correct way round for chinese
YYYY/MM/DD time:

Steve

Reply to this Message

Roedy Green - 22 Oct 2005 12:10 GMT

>actually the sql timestamps are the correct way round for chinese
>YYYY/MM/DD time:

yyyy-mm-dd is ISO standard 8601:1988

Signature

Canadian Mind Products, Roedy Green.
http://mindprod.com Again taking new Java programming contracts.

Reply to this Message

steve - 23 Oct 2005 22:35 GMT

>> actually the sql timestamps are the correct way round for chinese
>> YYYY/MM/DD time:
>
> yyyy-mm-dd is ISO standard 8601:1988

well they have been doing it for the last 1,000 years , so that would predate
the standard ;-)

Reply to this Message

Roedy Green - 24 Oct 2005 00:05 GMT

>well they have been doing it for the last 1,000 years , so that would predate
>the standard ;-)

The dashes were the ISO idea, a guess as an added hint this was not
one of the several /-date formats. The Canadian government used
yyyy.mm.dd at one point. I'd have to check if they have flipped to
ISO. That one might have been invented by a DSK typist (where . is a
very easy char to type).

I had a quick look at counting in Chinese. It looked so regular, it
could have been something a programmer would have invented, lacking
only base 16. Northern Europeans have the most irregular naming
systnem for numbers.

see http://mindprod.com/applets/inwords.html
for examples. (sorry no Chinese, but there is Japanese).

Signature

Canadian Mind Products, Roedy Green.
http://mindprod.com Again taking new Java programming contracts.

Reply to this Message

Fwd: Re: Date different

Free Magazines