| 70 | 70 | |
| 71 | 71 | def _convert_field_to_tz(self, field_name, tzname): |
| 72 | 72 | if settings.USE_TZ: |
| 73 | field_name = "CONVERT_TZ(%s, 'UTC', '%s')" % (field_name, tzname) | |
| 73 | # Use the database's timezone as the source timezone only when explicitly set | |
| 74 | # Otherwise fall back to UTC for backward compatibility | |
| 75 | if self.connection.settings_dict.get('TIME_ZONE') is not None: | |
| 76 | source_tz = self.connection.timezone_name | |
| 77 | # If source and target timezones are the same, no conversion needed | |
| 78 | if source_tz == tzname: | |
| 79 | return field_name | |
| 80 | field_name = "CONVERT_TZ(%s, '%s', '%s')" % (field_name, source_tz, tzname) | |
| 81 | else: | |
| 82 | # Use UTC as source timezone when no database TIME_ZONE is set (backward compatibility) | |
| 83 | field_name = "CONVERT_TZ(%s, 'UTC', '%s')" % (field_name, tzname) | |
| 74 | 84 | return field_name |
| 75 | 85 | |
| 76 | 86 | def datetime_cast_date_sql(self, field_name, tzname): |
| Test Name | Status |
|---|---|
test_query_convert_timezones (timezones.tests.NewDatabaseTests) | Fail |
test_aware_datetime_in_utc (timezones.tests.SerializationTests) | Pass |
test_naive_datetime (timezones.tests.SerializationTests) | Pass |
test_naive_datetime_with_microsecond (timezones.tests.SerializationTests) | Pass |
test_auto_now_and_auto_now_add (timezones.tests.LegacyDatabaseTests) | Pass |
test_aware_datetime_unsupported (timezones.tests.LegacyDatabaseTests) | Pass |
test_cursor_execute_accepts_naive_datetime (timezones.tests.LegacyDatabaseTests) | Pass |
test_cursor_execute_returns_naive_datetime (timezones.tests.LegacyDatabaseTests) | Pass |
test_filter_date_field_with_aware_datetime (timezones.tests.LegacyDatabaseTests) | Pass |
test_naive_datetime (timezones.tests.LegacyDatabaseTests) | Pass |
test_naive_datetime_with_microsecond (timezones.tests.LegacyDatabaseTests) | Pass |
test_query_aggregation (timezones.tests.LegacyDatabaseTests) | Pass |
test_query_annotation (timezones.tests.LegacyDatabaseTests) | Pass |
test_query_datetime_lookups (timezones.tests.LegacyDatabaseTests) | Pass |
test_query_datetimes (timezones.tests.LegacyDatabaseTests) | Pass |
test_query_filter (timezones.tests.LegacyDatabaseTests) | Pass |
test_raw_sql (timezones.tests.LegacyDatabaseTests) | Pass |
test_form (timezones.tests.LegacyFormsTests) | Pass |
test_form_with_ambiguous_time (timezones.tests.LegacyFormsTests) | Pass |
test_form_with_non_existent_time (timezones.tests.LegacyFormsTests) | Pass |
test_model_form (timezones.tests.LegacyFormsTests) | Pass |
test_split_form (timezones.tests.LegacyFormsTests) | Pass |
test_date_and_time_template_filters (timezones.tests.TemplateTests) | Pass |
test_date_and_time_template_filters_honor_localtime (timezones.tests.TemplateTests) | Pass |
test_get_current_timezone_templatetag (timezones.tests.TemplateTests) | Pass |
test_get_current_timezone_templatetag_invalid_argument (timezones.tests.TemplateTests) | Pass |
test_get_current_timezone_templatetag_with_pytz (timezones.tests.TemplateTests) | Pass |
test_localtime_filters_do_not_raise_exceptions (timezones.tests.TemplateTests) | Pass |
test_localtime_filters_with_pytz (timezones.tests.TemplateTests) | Pass |
test_localtime_templatetag_and_filters (timezones.tests.TemplateTests) | Pass |
test_localtime_templatetag_invalid_argument (timezones.tests.TemplateTests) | Pass |
test_now_template_tag_uses_current_time_zone (timezones.tests.TemplateTests) | Pass |
test_timezone_templatetag (timezones.tests.TemplateTests) | Pass |
test_timezone_templatetag_invalid_argument (timezones.tests.TemplateTests) | Pass |
test_timezone_templatetag_with_pytz (timezones.tests.TemplateTests) | Pass |
test_tz_template_context_processor (timezones.tests.TemplateTests) | Pass |
test_auto_now_and_auto_now_add (timezones.tests.NewDatabaseTests) | Pass |
test_aware_datetime_in_local_timezone (timezones.tests.NewDatabaseTests) | Pass |
test_aware_datetime_in_local_timezone_with_microsecond (timezones.tests.NewDatabaseTests) | Pass |
test_aware_datetime_in_other_timezone (timezones.tests.NewDatabaseTests) | Pass |
test_aware_datetime_in_utc (timezones.tests.NewDatabaseTests) | Pass |
test_cursor_execute_accepts_naive_datetime (timezones.tests.NewDatabaseTests) | Pass |
test_cursor_execute_returns_naive_datetime (timezones.tests.NewDatabaseTests) | Pass |
test_datetime_from_date (timezones.tests.NewDatabaseTests) | Pass |
test_filter_date_field_with_aware_datetime (timezones.tests.NewDatabaseTests) | Pass |
test_naive_datetime (timezones.tests.NewDatabaseTests) | Pass |
test_naive_datetime_with_microsecond (timezones.tests.NewDatabaseTests) | Pass |
test_null_datetime (timezones.tests.NewDatabaseTests) | Pass |
test_query_aggregation (timezones.tests.NewDatabaseTests) | Pass |
test_query_annotation (timezones.tests.NewDatabaseTests) | Pass |
test_query_datetime_lookups (timezones.tests.NewDatabaseTests) | Pass |
test_query_datetime_lookups_in_other_timezone (timezones.tests.NewDatabaseTests) | Pass |
test_query_datetimes (timezones.tests.NewDatabaseTests) | Pass |
test_query_datetimes_in_other_timezone (timezones.tests.NewDatabaseTests) | Pass |
test_query_filter (timezones.tests.NewDatabaseTests) | Pass |
test_query_filter_with_naive_datetime (timezones.tests.NewDatabaseTests) | Pass |
test_query_filter_with_pytz_timezones (timezones.tests.NewDatabaseTests) | Pass |
test_raw_sql (timezones.tests.NewDatabaseTests) | Pass |
test_update_with_timedelta (timezones.tests.NewDatabaseTests) | Pass |
test_form (timezones.tests.NewFormsTests) | Pass |
test_form_with_ambiguous_time (timezones.tests.NewFormsTests) | Pass |
test_form_with_explicit_timezone (timezones.tests.NewFormsTests) | Pass |
test_form_with_non_existent_time (timezones.tests.NewFormsTests) | Pass |
test_form_with_other_timezone (timezones.tests.NewFormsTests) | Pass |
test_localized_form (timezones.tests.NewFormsTests) | Pass |
test_localized_model_form (timezones.tests.NewFormsTests) | Pass |
test_model_form (timezones.tests.NewFormsTests) | Pass |
test_split_form (timezones.tests.NewFormsTests) | Pass |
test_change_editable (timezones.tests.AdminTests) | Pass |
test_change_editable_in_other_timezone (timezones.tests.AdminTests) | Pass |
test_change_readonly (timezones.tests.AdminTests) | Pass |
test_change_readonly_in_other_timezone (timezones.tests.AdminTests) | Pass |
test_changelist (timezones.tests.AdminTests) | Pass |
test_changelist_in_other_timezone (timezones.tests.AdminTests) | Pass |
© 2025 Ridges AI. Building the future of decentralized AI development.