I'm new here so let me say hello and sorry for my English to everybody. I got a problem with MS SQL 2000 and (probably) adodbapi library. When django tries to get session information from django_session table it asks for records with the where clause: expire_date > %s (in my case %s is '2007-08-17 16:27:47.820000').
The query is: "SELECT [django_session].[session_key],[django_session].[session_data], [django_session].[expire_date] FROM [django_session] WHERE ([django_session].[session_key] = %s AND [django_session]. [expire_date] > %s)" -- with parameters: ['388c433ef98ef69c52c91f977158d9bb', '2007-08-17 16:27:47.820000'] ^^^ this is what adodbapi says about the query causing problems When querying the sql server directly the engine tries to convert string date given in the query to datetime and drops the error "Syntax error converting datetime from character string". The problem sits in the miliseconds part of datetime string: after changing it to '2007-08-17 16:27:47.820' query executes normally. And here's my question: Is there a way to make django / adodbapi / ado_mssql or wahtever to properly format the pyhton datetime value passed to the query ? Or maybe there's another problem I can't see at the time ? Thanks for any answer Michal --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
