[Zope] Storing a ZopeTime() within an MS Access DB

[McDonnell, Larry]

Hi,

How can it be a float when the <dtml-var temp_date> returns 2002/09/30
15:49:23.74 GMT-4??

-----Original Message-----
From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Max M
Sent: Monday, September 30, 2002 1:48 PM
To: McDonnell, Larry
Cc: 'Zope@Zope.Org' (E-mail)
Subject: Re: [Zope] Storing a ZopeTime() within an MS Access DB


McDonnell, Larry wrote:


> I am running into a wall when it comes to populating the variable
arch_date
> with ZopeTime. I have a web form that I need to generate an audit trail.
> Before I write the updated record, I dtml-in the active table and write
the
> "old" information in an archive table. I added a date field (arch_date) to
> the archive table but I do not know how to save the variable in my ZSQL
> Method.


I believe that DateTime is in fact a float and that you will probably 
need to convert it to a string of the correct format. Then your database 
will probably automatically convert it to an internal date format.


regards Max M

 ><evolve>
   >    >


_______________________________________________
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 )