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 )