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)



Subject: TZH:TZM
Download (untitled) / with headers
text/plain 620b
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'.
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>
Download (untitled) / with headers
text/plain 784b
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.

Download (untitled) / with headers
text/plain 487b
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.


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.