Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

[Info-Ingres] II_DATE_FORMAT ISO and ISO4

71 views
Skip to first unread message

Martin Bowes

unread,
Oct 27, 2009, 6:56:30 AM10/27/09
to Ingres and related product discussion forum

Hi All,

 

Is there any reason why when I set date_format to ISO4 and do a select date('now') that I get: 20091027 10:53:46

and not: 20091027T10:53:46?

 

If I read ISO8601 correctly the date and time fields should be seperated by a 'T' not a space.

 

Is this a bug?

 

Martin Bowes

John Smedley

unread,
Oct 27, 2009, 8:35:24 AM10/27/09
to Ingres and related product discussion forum

In the copy of the standard that I read, it states:

 

NOTE: By mutual agreement of the partners in information interchange, the character [T] may be omitted in applications

where there is no risk of confusing a combined date and time of the day representation with others defined in this International

Standard.

 

In my opinion not a bug

Ian Kirkham

unread,
Oct 27, 2009, 8:37:43 AM10/27/09
to Ingres and related product discussion forum

Hi Marty,

I think that the ISO and ISO4 date formats simply pre-date ISO8601.

Do you need it to?

Regards,

Ian

 

From: info-ingr...@kettleriverconsulting.com [mailto:info-ingr...@kettleriverconsulting.com] On Behalf Of Martin Bowes
Sent: 27 October 2009 10:57
To: Ingres and related product discussion forum
Subject: [Info-Ingres] II_DATE_FORMAT ISO and ISO4

Martin Bowes

unread,
Oct 27, 2009, 9:06:34 AM10/27/09
to Ingres and related product discussion forum, John Smedley

Hi John,

 

Thanks for that. I'l l wave that at my boss as he's been bitching about this.

 

Marty

 


Sent: 27 October 2009 12:35
To: Ingres and related product discussion forum

Subject: Re: [Info-Ingres] II_DATE_FORMAT ISO and ISO4

 

In the copy of the standard that I read, it states:

 

NOTE: By mutual agreement of the partners in information interchange, the character [T] may be omitted in applications

where there is no risk of confusing a combined date and time of the day representation with others defined in this International

Standard.

 

In my opinion not a bug

 


Sent: 27 October 2009 10:57
To: Ingres and related product discussion forum
Subject: [Info-Ingres] II_DATE_FORMAT ISO and ISO4

Martin Bowes

unread,
Oct 27, 2009, 9:13:15 AM10/27/09
to Ingres and related product discussion forum, Ian Kirkham, John Smedley

Hi Ian, John

 

It'd be handy if we could define something like  II_ISO_DATE_FMT and have its value alter the format of the output.

 

Eg. For II_DATE_FORMAT = ISO4…

II_ISO_DATE_FMT

0 (or undefined)               yyyymmdd [hh:mm:ss]

1                                              yyyymmdd [hhmmss]

2                                              yyyymmdd[Thh:mm:ss]

3                                              yyyymmdd[Thhmmss]

 

And you get the idea for ISO settings.

 

Marty

 

From: info-ingr...@kettleriverconsulting.com [mailto:info-ingr...@kettleriverconsulting.com] On Behalf Of Ian Kirkham
Sent: 27 October 2009 12:38
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] II_DATE_FORMAT ISO and ISO4

 

Hi Marty,

I think that the ISO and ISO4 date formats simply pre-date ISO8601.

Do you need it to?

Regards,

Ian

 


Sent: 27 October 2009 10:57
To: Ingres and related product discussion forum
Subject: [Info-Ingres] II_DATE_FORMAT ISO and ISO4

John Smedley

unread,
Oct 27, 2009, 9:21:45 AM10/27/09
to Martin Bowes, Ingres and related product discussion forum, Ian Kirkham

Why introduce another environment variable?

 

Why not have ISO4 or ISO4T or ISO4T[no]colon or ISO4[no]colon or some such

 

John

Martin Bowes

unread,
Oct 27, 2009, 9:23:43 AM10/27/09
to John Smedley, Ingres and related product discussion forum, Ian Kirkham

I'm happy either way…

 

Marty

Ingres Forums

unread,
Oct 27, 2009, 10:40:44 AM10/27/09
to

How about II_DATE_FORMAT='dd-mon-yyyy hh24:mi' style of date choice?


--
nick....@barclays.com
------------------------------------------------------------------------
nick....@barclays.com's Profile: http://community.ingres.com/forum/member.php?userid=733
View this thread: http://community.ingres.com/forum/showthread.php?t=11293

Martin Bowes

unread,
Oct 28, 2009, 5:13:18 AM10/28/09
to Ingres and related product discussion forum, nick....@barclays.com
Hi Nick,

What you'd want is something along the lines of the report writer date
format command.

I'm considering making the ISO4T... an Opensource project. I suspect the
report writer style may be a bit beyond me but I'll certainly consider
it when I have a look at the code required.

Marty

-----Original Message-----
From: info-ingr...@kettleriverconsulting.com
[mailto:info-ingr...@kettleriverconsulting.com] On Behalf Of
Ingres Forums
Sent: 27 October 2009 14:41
To: info-...@kettleriverconsulting.com
Subject: Re: [Info-Ingres] II_DATE_FORMAT ISO and ISO4

_______________________________________________
Info-Ingres mailing list
Info-...@kettleriverconsulting.com
http://ext-cando.kettleriverconsulting.com/mailman/listinfo/info-ingres


Martin Bowes

unread,
Oct 28, 2009, 5:14:33 AM10/28/09
to Ingres and related product discussion forum, Ian Kirkham, John Smedley

I can smell an Opensource project!

 

Any hints where I should start looking…

 

Marty

 


Sent: 27 October 2009 13:24
To: John Smedley; Ingres and related product discussion forum
Cc: Ian Kirkham

Subject: Re: [Info-Ingres] II_DATE_FORMAT ISO and ISO4

 

I'm happy either way…

Subject: Re: [Info-Ingres] II_DATE_FORMAT ISO and ISO4

 

Hi Marty,

0 new messages