[Zope] UTC

Tom Deprez Tom Deprez" <tom.deprez@uz.kuleuven.ac.be
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."
> +-------------------------------------------+