On 12/4/06, John Siracusa <[EMAIL PROTECTED]> wrote:
> In that case, it seems like we can't support the default format since
> there's no way to know how to inflate that into a DateTime object. So I
> guess we're back to a default nls_date_format setting in post_connect_sql
> for Oracle. Blah.
B
On 12/4/06 8:02 PM, Clayton Scott wrote:
> On 12/4/06, John Siracusa <[EMAIL PROTECTED]> wrote:
>> Well what does Oracle do? Is a YY value of 50 the year 1950 or 2050
>> or something else? And so on for 00-99. And what about the 1800s and
>> 2100s? Basically, to parse YY, we have to know exactl
On 12/4/06, John Siracusa <[EMAIL PROTECTED]> wrote:
> Well what does Oracle do? Is a YY value of 50 the year 1950 or 2050
> or something else? And so on for 00-99. And what about the 1800s and
> 2100s? Basically, to parse YY, we have to know exactly what Oracle
> does so we can follow the sam
On 12/4/06, Clayton Scott <[EMAIL PROTECTED]> wrote:
> On 12/4/06, John Siracusa <[EMAIL PROTECTED]> wrote:
>> On 12/4/06, Clayton Scott <[EMAIL PROTECTED]> wrote:
>>> There is a default (in the english world) of DD-MON-YY (23-JAN-00)
>>
>> Ick! A two-digit year? What are the rules for parsing th
On 12/4/06, John Siracusa <[EMAIL PROTECTED]> wrote:
> On 12/4/06, Clayton Scott <[EMAIL PROTECTED]> wrote:
> > On 12/4/06, John Siracusa <[EMAIL PROTECTED]> wrote:
> >> Perhaps Rose::DB::Oracle could have a hard-coded default bit of
> >> post_connect_sql to set nls_date_format, but I'd prefer it i
D]
[mailto:[EMAIL PROTECTED] On Behalf Of John
Siracusa
Sent: Monday, December 04, 2006 2:59 PM
To: Rose::DB::Object list
Subject: Re: [RDBO] Oracle and DateTime
On 12/4/06, Clayton Scott <[EMAIL PROTECTED]> wrote:
> On 12/4/06, John Siracusa <[EMAIL PROTECTED]> wrote:
>> Pe
On 12/4/06, Clayton Scott <[EMAIL PROTECTED]> wrote:
> On 12/4/06, John Siracusa <[EMAIL PROTECTED]> wrote:
>> Perhaps Rose::DB::Oracle could have a hard-coded default bit of
>> post_connect_sql to set nls_date_format, but I'd prefer it if I could
>> handle whatever Oracle produces if you do not se
On 12/4/06, John Siracusa <[EMAIL PROTECTED]> wrote:
> Perhaps Rose::DB::Oracle could have a hard-coded default bit of
> post_connect_sql to set nls_date_format, but I'd prefer it if I could
> handle whatever Oracle produces if you do not set nls_date_format
> explicitly. Or is there no default a
On 12/4/06, Kevin McGrath <[EMAIL PROTECTED]> wrote:
> For now I've added the following code to my init_db function in my base
> module:
>
> sub init_db {
> my $db = My::DB->new;
> my $dbh = $db->dbh or die $db->error;
> $dbh->do(q[alter session set nls_date_format = '-mm-dd
> hh24:
