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