Hi John,
You are probably passing datefirst as string while in your database
datefirst column is int.
Can you please confirm you are not passing different data types?
Cheers,
Adnan
On Thursday, July 4, 2019 at 6:48:21 PM UTC+2, John Burke wrote:
>
> I don't actually supply the hour. This is code in base.py.
>
> The prior code sets up formatting:
>
> datefirst = options.get('datefirst', 7)
> cursor.execute('SET DATEFORMAT ymd; SET DATEFIRST %s' % datefirst)
>
> I wonder if it is not getting executed successfully.
>
>
> On Thu, Jul 4, 2019 at 11:10 AM Charlotte Wood <
> [email protected] <javascript:>> wrote:
>
>> It looks as if you have an odd value in there for the hour. Do you?
>>
>>
>> Charlotte Wood, MEd
>>
>> Educator
>>
>> (405) 578-5701
>>
>> Zoom Meeting ID#: 4055785701
>>
>> *Zoom URL:* https://epiccharterschools.zoom.us/j/2970513912
>>
>> Classroom Google Site:
>> https://sites.google.com/epiccharterschools.org/charlottewoodclassroom/home
>>
>> Epic Technical Support: (405) 652-0935
>>
>>
>>
>> Jordan McKesson Principal
>>
>> 405-749-4550 ext. 309
>>
>> [email protected] <javascript:>
>>
>> <http://facebook.com/epiccharterschools>
>> <https://twitter.com/epiccharter>
>> <https://www.instagram.com/epiccharterschools/>
>> <https://www.youtube.com/user/EpicCharterSchools>
>>
>>
>>
>>
>> On Wed, Jul 3, 2019 at 6:52 PM John Burke <[email protected] <javascript:>>
>> wrote:
>>
>>> Trying to connect to SQL Server from Django
>>>
>>> DATABASES = {
>>> 'default': {
>>> 'ENGINE': 'sql_server.pyodbc',
>>> 'NAME': 'dbname',
>>> 'HOST': 'hostname',
>>> 'PORT': '',
>>> 'USER': 'user',
>>> 'PASSWORD': 'password',
>>> 'OPTIONS': {
>>> 'driver': 'ODBC Driver 13 for SQL Server',
>>> },
>>> }
>>> }
>>>
>>>
>>> I get the following error:
>>> File "...\venv\lib\site-packages\sql_server\pyodbc\base.py", line 362,
>>> in init_connection_state
>>> val = cursor.execute('SELECT SYSDATETIME()').fetchone()[0]
>>> ValueError: hour must be in 0..23
>>>
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "Django users" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to [email protected] <javascript:>.
>>> To post to this group, send email to [email protected]
>>> <javascript:>.
>>> Visit this group at https://groups.google.com/group/django-users.
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/django-users/58c14df7-0b4e-49dd-a19e-11c1101ff947%40googlegroups.com
>>>
>>> <https://groups.google.com/d/msgid/django-users/58c14df7-0b4e-49dd-a19e-11c1101ff947%40googlegroups.com?utm_medium=email&utm_source=footer>
>>> .
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Django users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected] <javascript:>.
>> To post to this group, send email to [email protected]
>> <javascript:>.
>> Visit this group at https://groups.google.com/group/django-users.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/django-users/CAPZR0N6yPmqDRwfbSXNwUHOCR3%3DDcgTM_Ez_DcM7FbxjAsSFGA%40mail.gmail.com
>>
>> <https://groups.google.com/d/msgid/django-users/CAPZR0N6yPmqDRwfbSXNwUHOCR3%3DDcgTM_Ez_DcM7FbxjAsSFGA%40mail.gmail.com?utm_medium=email&utm_source=footer>
>> .
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
> --
> Regards,
> John B
>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/c532c7ff-2635-4e7d-a393-206d6d01634b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
