Le 12 févr. 2013 à 23:12, Ian Kelly a écrit :
> On Tue, Feb 12, 2013 at 3:06 PM, Ian Kelly wrote:
>>
>> I encounter the same bug in Oracle 10g XE. I tried it also on an 11.2
>> database, and it seemed to work, but I ran into a different issue:
>> neither of the time zones 'Africa/Nairobi' nor
On Tue, Feb 12, 2013 at 3:06 PM, Ian Kelly wrote:
> On Tue, Feb 12, 2013 at 2:25 PM, Aymeric Augustin
> wrote:
> c.execute("""SELECT "DT" FROM "TIMEZONES_EVENT" WHERE EXTRACT(MONTH FROM
> CAST((FROM_TZ("DT", 'UTC') AT TIME ZONE (:arg)) AS DATE)) = 1""",
> ['Africa/Nairobi']).fetchal
On Tue, Feb 12, 2013 at 2:25 PM, Aymeric Augustin
wrote:
c.execute("""SELECT "DT" FROM "TIMEZONES_EVENT" WHERE EXTRACT(MONTH FROM
CAST((FROM_TZ("DT", 'UTC') AT TIME ZONE (:arg)) AS DATE)) = 1""",
['Africa/Nairobi']).fetchall()
> Traceback (most recent call last):
> File "", line
I spent the better part of the day struggling with Oracle and unsurprisingly
nothing works :(
Given this model:
class Event(models.Model):
dt = models.DateTimeField()
I'm trying to implement this query with time zone support enabled:
Event.objects.filter(dt__month=1)
That's a
On 12 helmi, 14:10, Emil Stenström wrote:
> On Monday, 4 February 2013 15:06:18 UTC+1, Aymeric Augustin wrote:
>
> > Hi Luke,
>
> > This sounds like a good compromise between security and usability.
>
> I just want to add another voice of support for Option 3 to this thread.
>
> I'm one of the dev
On Monday, 4 February 2013 15:06:18 UTC+1, Aymeric Augustin wrote:
>
> Hi Luke,
>
> This sounds like a good compromise between security and usability.
>
I just want to add another voice of support for Option 3 to this thread.
I'm one of the developers for a large site, with ~40 apps, that has g
On 11 Feb 2013, at 23:46, Russell Keith-Magee wrote:
> Hi Alessandro,
>
> On Tue, Feb 12, 2013 at 2:30 AM, Alessandro Dentella wrote:
> Hi,
>
> this email aims at finding a bettere solution to a problem that was already
> posted some months ago in the user list [1]. If you use namespaces in