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

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



From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) 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



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

Hi Marty,

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

Do you need it to?

Regards,

Ian



________________________________

From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) 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



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

Hi John,



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



Marty



From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of John
Smedley
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



From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) 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



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

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-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) 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



________________________________

From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) 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



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

Why introduce another environment variable?



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



John



From: Martin Bowes [mailto:martin.bowes (AT) ctsu (DOT) ox.ac.uk]
Sent: 27 October 2009 13:13
To: Ingres and related product discussion forum
Cc: Ian Kirkham; John Smedley
Subject: RE: [Info-Ingres] II_DATE_FORMAT ISO and ISO4



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-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) 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



________________________________

From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) 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



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

I'm happy either way...



Marty



From: John Smedley [mailto:John.Smedley (AT) ingres (DOT) com]
Sent: 27 October 2009 13:22
To: Martin Bowes; Ingres and related product discussion forum
Cc: Ian Kirkham
Subject: RE: [Info-Ingres] II_DATE_FORMAT ISO and ISO4



Why introduce another environment variable?



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



John



From: Martin Bowes [mailto:martin.bowes (AT) ctsu (DOT) ox.ac.uk]
Sent: 27 October 2009 13:13
To: Ingres and related product discussion forum
Cc: Ian Kirkham; John Smedley
Subject: RE: [Info-Ingres] II_DATE_FORMAT ISO and ISO4



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-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) 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



________________________________

From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) 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



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

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


--
nick.bolton (AT) barclays (DOT) com
------------------------------------------------------------------------
nick.bolton (AT) barclays (DOT) com's Profile: http://community.ingres.com/forum/member.php?userid=733
View this thread: http://community.ingres.com/forum/sh...ad.php?t=11293

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-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
Ingres Forums
Sent: 27 October 2009 14:41
To: info-ingres (AT) kettleriverconsulting (DOT) com
Subject: Re: [Info-Ingres] II_DATE_FORMAT ISO and ISO4


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


--
nick.bolton (AT) barclays (DOT) com
------------------------------------------------------------------------
nick.bolton (AT) barclays (DOT) com's Profile:
http://community.ingres.com/forum/member.php?userid=733
View this thread:
http://community.ingres.com/forum/sh...ad.php?t=11293

_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres

I can smell an Opensource project!



Any hints where I should start looking...



Marty



From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
Martin Bowes
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...



Marty



From: John Smedley [mailto:John.Smedley (AT) ingres (DOT) com]
Sent: 27 October 2009 13:22
To: Martin Bowes; Ingres and related product discussion forum
Cc: Ian Kirkham
Subject: RE: [Info-Ingres] II_DATE_FORMAT ISO and ISO4



Why introduce another environment variable?



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



John



From: Martin Bowes [mailto:martin.bowes (AT) ctsu (DOT) ox.ac.uk]
Sent: 27 October 2009 13:13
To: Ingres and related product discussion forum
Cc: Ian Kirkham; John Smedley
Subject: RE: [Info-Ingres] II_DATE_FORMAT ISO and ISO4



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-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) 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



________________________________

From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) 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



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