OK, situation I deal with is that I have many events, each event is scheduled for some date and time (like 1 april 2009, 1pm).
I want to make query that retrieve all events that are scheduled between 3pm-5pm (na matter what day) or are scheduled before 2pm (no matter what day) or sth simillar. It might sound quite strange but in case of that project this is quite obvious situation. I can split datetimefield to datefield and timefield but I will miss some other advantages then, I think. I just wondered if there is some way to get time part from datetimefield (like using python: datetime.now().time()) in Django query. Anyway, thanks for response Regards, L On 31 Mar, 17:04, Brian Neal <bgn...@gmail.com> wrote: > On Mar 31, 5:31 am, LD <l.dzied...@gmail.com> wrote: > > > OK, but Django do not provide 'time' lookup so my problem is 'how to > > retrieve time part of datetime field in a query' > > Ok, then why are you storing date and time together when all you care > about is time? To me, when you have a DateTimeField, that represents a > point in time. It doesn't make a lot of sense to ask: "does this point > in time occur less than 14:00 hours." 14:00 hours on what day? Today? > Yesterday? That is the source of friction for me. Maybe you could > explain your model a bit more. > > Maybe you should consider using a TimeField instead, then your query > would be more natural. > > But if you really do need to store dates and times together, then yes, > I don't think there is an easy way to just query on the time part of > the DateTime field. You might look into the new F() syntax, but you > might just have to write your own SQL. --~--~---------~--~----~------------~-------~--~----~ 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 django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
