[Zope] on dates

massimop at users.berlios.de massimop at users.berlios.de
Mon Oct 11 15:18:42 EDT 2004


On Tue, 2004-10-12 at 07:49 +1300, Les Ferguson wrote:
> I am using this in a query to MySql...
> 
>     SELECT Job_id, DATE_FORMAT(Job_Date,"%d %b %Y") as Job_Date
>     FROM Jobs  ...etc...
> 
thanks, this looks like a good workaround
(but now it's war, I have to know why I can't get it working the other
way...)

> This allows me to retrieve Job_Date how ever I need it at the time. The 
> format codes for MySql are similar to strftime in Python.  Also, from 
> within a python script I have used:
> 
>     today=DateTime().strftime("%d %b %Y")
> 
> The DateTime() type should be available in your script environment, and 
> I believe you can pass your data value to DateTime() and it will 
> initialize to a valid Python datetime object.
> 
sigh... you can read the result in another post...
> -- 
> Les Ferguson
> Software developer
> Waitakere, NZ
> 
thanks
massimo




More information about the Zope mailing list