Skip Menu |

This queue is for tickets about the Convert-NLS_DATE_FORMAT CPAN distribution.

Report information
The Basics
Id: 36004
Status: open
Priority: 0/
Queue: Convert-NLS_DATE_FORMAT
People
Owner: Nobody in particular
Requestors: jozef [...] kutej.net
Cc:
AdminCc:
Bug Information
Severity: Unimportant
Broken in: 0.02
Fixed in: (no value)
Attachments
signature.asc

History Show all quoted text
  Mon May 19 08:47:48 2008 jozef [...] kutej.net - Ticket created
Subject: TZH:TZM
Timezone format elements in Convert::NLS_DATA_FORMAT are: TZHTZM=> '%z', # time zone hour offset from UTC TZH => '%z', TZR => '%Z', # time zone name TZHTZM, TZR works fine. TZH should return just hour offset but currently it's the same as TZHTZM. TZM is not implemented at all. (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements004.htm#i34924) POSIX has no equivalents to TZH or TZM so there is no way to implement it but it will probably make sence to die or warn if somebody tries to use TZH or TZM alone as on the oracle page there are a lot of examples like 'HH:MI:SS.FFTZH:TZM'.
  Mon May 19 14:08:46 2008 kolibrie [...] cpan.org - Correspondence added
Subject: Re: [rt.cpan.org #36004] TZH:TZM
Date: Mon, 19 May 2008 14:08:22 -0400
To: Jozef Kutej via RT <bug-Convert-NLS_DATE_FORMAT [...] rt.cpan.org>
From: Nathan Gray <kolibrie [...] cpan.org>
On Mon, May 19, 2008 at 08:47:49AM -0400, Jozef Kutej via RT wrote: Show quoted text
> POSIX has no equivalents to TZH or TZM so there is no way to implement > it but it will probably make sence to die or warn if somebody tries to > use TZH or TZM alone as on the oracle page there are a lot of examples > like 'HH:MI:SS.FFTZH:TZM'.
Other Oracle formats that are not supported by POSIX just leave the original string intact, such as: P.M. I'm more likely to lean towards that behavior (TZH and TZM would just not be substituted) rather than warning or dying, since that is how other formats are handled. Hopefully the user would notice that those strings did not get converted. Perhaps documentation could be added to warn the user of formats which do not have a POSIX counterpart. -kolibrie
Download signature.asc
application/pgp-signature 189b

Message body not shown because it is not plain text.

  Mon May 19 14:08:48 2008 The RT System itself - Status changed from 'new' to 'open'
  Tue May 20 03:49:36 2008 jozef [...] kutej.net - Correspondence added
On Mon May 19 14:08:46 2008, kolibrie@cpan.org wrote: Show quoted text
> I'm more likely to lean towards that behavior (TZH and TZM would just > not be substituted) rather than warning or dying, since that is how > other formats are handled. Hopefully the user would notice that those > strings did not get converted. Perhaps documentation could be added > to warn the user of formats which do not have a POSIX counterpart. >
Yes you are right, short note in a pod will be enough. Thank you, Jozef.