[Zope] UTC
Garry Steedman
gs@styrax.com
Tue, 18 Dec 2001 17:19:03 +0000
details?
g
On 18 Dec 2001, at 17:17, 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 17:17:07 +0100
> Oops, sorry,
>
> wrong, it doesn't work. I was looking wrongly when I thought we had
> the solution.
>
> Tom.
> ----- Original Message -----
> From: "Tom Deprez" <tom.deprez@uz.kuleuven.ac.be>
> To: <gs@styrax.com>
> Cc: <zope@zope.org>
> Sent: Tuesday, December 18, 2001 5:08 PM
> Subject: Re: [Zope] UTC
>
>
> > 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 )
> >
> >
> > _______________________________________________
> > 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."
+-------------------------------------------+