using mysql.
model: only the times are relevant.
class Time(models.Model):
start = models.DateTimeField("zeitbeginn")
end = models.DateTimeField("zeitende",
blank=True,null=True)
user = models.ForeignKey(User)
project = models.ForeignKey(Project,verbose_name="Projekt")
phase = models.ForeignKey(Phase, verbose_name="Phase",
blank=True, null=True)
comment = models.CharField("kommentar",max_length=100,null=True)
telearbeit = models.NullBooleanField(blank=True, null=True)
if i look at at the sql when i filter with datetime.
Time.objects.filter(start__gt=datetime.now()).query.as_sql()[0] %
Time.objects.filter(start__gt=datetime.now()).query.as_sql()[1]
i get this:
SELECT `time_manager_time`.`id`, `time_manager_time`.`start`,
`time_manager_time`.`end`, `time_manager_time`.`user_id`,
`time_manager_time`.`project_id`, `time_manager_time`.`phase_id`,
`time_manager_time`.`comment`, `time_manager_time`.`telearbeit` FROM
`time_manager_time` WHERE `time_manager_time`.`start` > 2009-07-13
17:59:12 ORDER BY `time_manager_time`.`start` DESC
if i try to run the query manually, i get an error. mysql wants quotes
around the date:
SELECT `time_manager_time`.`id`, `time_manager_time`.`start`,
`time_manager_time`.`end`, `time_manager_time`.`user_id`,
`time_manager_time`.`project_id`, `time_manager_time`.`phase_id`,
`time_manager_time`.`comment`, `time_manager_time`.`telearbeit` FROM
`time_manager_time` WHERE `time_manager_time`.`start` > '2009-07-13
17:59:12' ORDER BY `time_manager_time`.`start` DESC
but using the queryset works. havent been able to find out why
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/django-developers?hl=en
-~----------~----~----~----~------~----~------~--~---
