[Zope] UTC

[Tom Deprez]

hey,

yes, the 'normal' things works :-)!

sometimes you don't have to look that far :-)

Thanks, Tom

----- Original Message ----- 
From: "Garry Steedman" <gs@styrax.com>
To: "Tom Deprez" <tom.deprez@uz.kuleuven.ac.be>
Cc: <zope@zope.org>
Sent: Tuesday, December 18, 2001 5:53 PM
Subject: Re: [Zope] UTC


> Tom,
> 
> oracle privileges + roles = bleuch!
> 
> so you can do a select so long as it doesn't use a built-in function? 
> seems a bit odd to me, but luckily i'm a not an oracle dba either...
> 
> i'm not connected to an oracle box at the minute but doesn't the 
> "normal" ("_.str()") string conversion stuff work? 
> 
> cheers,
> 
> g
> 
> On 18 Dec 2001, at 16:32, Tom Deprez wrote:
> 
> Send reply to:  "Tom Deprez" <tom.deprez@uz.kuleuven.ac.be>
> From:           "Tom Deprez" <tom.deprez@uz.kuleuven.ac.be>
> To:             <gs@styrax.com>
> Copies to:      <zope@zope.org>
> Subject:        Re: [Zope] UTC
> Date sent:      Tue, 18 Dec 2001 16:32:36 +0100
> 
> > Thanks,
> > 
> > but ...
> > I can't since I've only read access to that database. It is a seperate
> > system here and more than read account we'll not get.
> > 
> > Tom.
> > ----- Original Message -----
> > From: "Garry Steedman" <gs@styrax.com>
> > To: "Tom Deprez" <tom.deprez@uz.kuleuven.ac.be>
> > Cc: <zope@zope.org>
> > Sent: Tuesday, December 18, 2001 5:24 PM
> > Subject: Re: [Zope] UTC
> > 
> > 
> > > Tom,
> > >
> > > what about doing it in oracle? i use oracle's to_char function:
> > >
> > > select to_char(date_field, 'DD-MM-YYYY') as myDate from
> > > random_table;
> > >
> > > cheers,
> > >
> > > Garry
> > >
> > >
> > > On 18 Dec 2001, at 16:05, Tom Deprez wrote:
> > >
> > > Send reply to:  "Tom Deprez" <tom.deprez@uz.kuleuven.ac.be>
> > > From:           "Tom Deprez" <tom.deprez@uz.kuleuven.ac.be>
> > > To:             <zope@zope.org>
> > > Subject:        [Zope] UTC
> > > Date sent:      Tue, 18 Dec 2001 16:05:14 +0100
> > >
> > > > Hi,
> > > >
> > > > I receive from oracle my datetime fields as a UTC float
> > > > presentation. Probably a stupid question, but how can I convert it
> > > > to a string presentation... all things I tried so far failed... I
> > > > must be doing something stupid, but I can't find the correct
> > > > syntax.
> > > >
> > > > Thanks, Tom.
> > > >
> > > >
> > > > _______________________________________________
> > > > Zope maillist  -  Zope@zope.org
> > > > http://lists.zope.org/mailman/listinfo/zope
> > > > **   No cross posts or HTML encoding!  **
> > > > (Related lists -
> > > >  http://lists.zope.org/mailman/listinfo/zope-announce
> > > >  http://lists.zope.org/mailman/listinfo/zope-dev )
> > >
> > >
> > > +-------------------------------------------+
> > >   Garry Steedman      mailto:gs@styrax.com
> > >   Styrax Associates  http://www.styrax.com/
> > >
> > >   "The Good Man has no shape."
> > > +-------------------------------------------+
> 
> 
> +-------------------------------------------+
>   Garry Steedman      mailto:gs@styrax.com  
>   Styrax Associates  http://www.styrax.com/ 
> 
>   "The Good Man has no shape."            
> +-------------------------------------------+
> 
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists - 
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )