[Zope] UTC

[Garry Steedman]

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."            
+-------------------------------------------+