| Computers Forum Index » Computer - Databases - Ingres » [Info-Ingres] II_DATE_FORMAT ISO and ISO4... |
|
Page 1 of 1 |
|
| Author |
Message |
| Martin Bowes... |
 Posted: Tue Oct 27, 2009 2:56 pm |
|
|
|
Guest
|
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 |
|
|
| Back to top |
|
|
|
| John Smedley... |
| Posted: Tue Oct 27, 2009 4:35 pm |
|
|
|
Guest
|
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 (no spam) kettleriverconsulting.com
[mailto:info-ingres-bounces at (no spam) 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
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 |
|
|
| Back to top |
|
|
|
| Ian Kirkham... |
| Posted: Tue Oct 27, 2009 4:37 pm |
|
|
|
Guest
|
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 (no spam) kettleriverconsulting.com
[mailto:info-ingres-bounces at (no spam) 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
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 |
|
|
| Back to top |
|
|
|
| Martin Bowes... |
| Posted: Tue Oct 27, 2009 5:06 pm |
|
|
|
Guest
|
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 (no spam) kettleriverconsulting.com
[mailto:info-ingres-bounces at (no spam) kettleriverconsulting.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 (no spam) kettleriverconsulting.com
[mailto:info-ingres-bounces at (no spam) 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
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 |
|
|
| Back to top |
|
|
|
| Martin Bowes... |
| Posted: Tue Oct 27, 2009 5:13 pm |
|
|
|
Guest
|
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 (no spam) kettleriverconsulting.com
[mailto:info-ingres-bounces at (no spam) 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
________________________________
From: info-ingres-bounces at (no spam) kettleriverconsulting.com
[mailto:info-ingres-bounces at (no spam) 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
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 |
|
|
| Back to top |
|
|
|
| John Smedley... |
| Posted: Tue Oct 27, 2009 5:21 pm |
|
|
|
Guest
|
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 (no spam) ctsu.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 (no spam) kettleriverconsulting.com
[mailto:info-ingres-bounces at (no spam) 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
________________________________
From: info-ingres-bounces at (no spam) kettleriverconsulting.com
[mailto:info-ingres-bounces at (no spam) 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
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 |
|
|
| Back to top |
|
|
|
| Martin Bowes... |
| Posted: Tue Oct 27, 2009 5:23 pm |
|
|
|
Guest
|
I'm happy either way...
Marty
From: John Smedley [mailto:John.Smedley at (no spam) ingres.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 (no spam) ctsu.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 (no spam) kettleriverconsulting.com
[mailto:info-ingres-bounces at (no spam) 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
________________________________
From: info-ingres-bounces at (no spam) kettleriverconsulting.com
[mailto:info-ingres-bounces at (no spam) 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
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 |
|
|
| Back to top |
|
|
|
| Ingres Forums... |
| Posted: Tue Oct 27, 2009 6:40 pm |
|
|
|
Guest
|
|
| Back to top |
|
|
|
| Martin Bowes... |
| Posted: Wed Oct 28, 2009 1:13 pm |
|
|
|
Guest
|
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 (no spam) kettleriverconsulting.com
[mailto:info-ingres-bounces at (no spam) kettleriverconsulting.com] On Behalf Of
Ingres Forums
Sent: 27 October 2009 14:41
To: info-ingres at (no spam) kettleriverconsulting.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 (no spam) barclays.com
------------------------------------------------------------------------
nick.bolton at (no spam) 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
_______________________________________________
Info-Ingres mailing list
Info-Ingres at (no spam) kettleriverconsulting.com
http://ext-cando.kettleriverconsulting.com/mailman/listinfo/info-ingres |
|
|
| Back to top |
|
|
|
| Martin Bowes... |
| Posted: Wed Oct 28, 2009 1:14 pm |
|
|
|
Guest
|
I can smell an Opensource project!
Any hints where I should start looking...
Marty
From: info-ingres-bounces at (no spam) kettleriverconsulting.com
[mailto:info-ingres-bounces at (no spam) kettleriverconsulting.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 (no spam) ingres.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 (no spam) ctsu.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 (no spam) kettleriverconsulting.com
[mailto:info-ingres-bounces at (no spam) 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
________________________________
From: info-ingres-bounces at (no spam) kettleriverconsulting.com
[mailto:info-ingres-bounces at (no spam) 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
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 |
|
|
| Back to top |
|
|
|
|
