1 files changed, 76 insertions, 0 deletions
diff --git a/activerecord/test/cases/date_time_test.rb b/activerecord/test/cases/date_time_test.rb
new file mode 100644
index 0000000000..b5f35aff0e
--- /dev/null
+++ b/activerecord/test/cases/date_time_test.rb
@@ -0,0 +1,76 @@
+# frozen_string_literal: true
+
+require "cases/helper"
+require "models/topic"
+require "models/task"
+
+class DateTimeTest < ActiveRecord::TestCase
+  include InTimeZone
+
+  def test_saves_both_date_and_time
+    with_env_tz "America/New_York" do
+      with_timezone_config default: :utc do
+        time_values = [1807, 2, 10, 15, 30, 45]
+        # create DateTime value with local time zone offset
+        local_offset = Rational(Time.local(*time_values).utc_offset, 86400)
+        now = DateTime.civil(*(time_values + [local_offset]))
+
+        task = Task.new
+        task.starting = now
+        task.save!
+
+        # check against Time.local, since some platforms will return a Time instead of a DateTime
+        assert_equal Time.local(*time_values), Task.find(task.id).starting
+      end
+    end
+  end
+
+  def test_assign_empty_date_time
+    task = Task.new
+    task.starting = ""
+    task.ending = nil
+    assert_nil task.starting
+    assert_nil task.ending
+  end
+
+  def test_assign_bad_date_time_with_timezone
+    in_time_zone "Pacific Time (US & Canada)" do
+      task = Task.new
+      task.starting = "2014-07-01T24:59:59GMT"
+      assert_nil task.starting
+    end
+  end
+
+  def test_assign_empty_date
+    topic = Topic.new
+    topic.last_read = ""
+    assert_nil topic.last_read
+  end
+
+  def test_assign_empty_time
+    topic = Topic.new
+    topic.bonus_time = ""
+    assert_nil topic.bonus_time
+  end
+
+  def test_assign_in_local_timezone
+    now = DateTime.civil(2017, 3, 1, 12, 0, 0)
+    with_timezone_config default: :local do
+      task = Task.new starting: now
+      assert_equal now, task.starting
+    end
+  end
+
+  def test_date_time_with_string_value_with_subsecond_precision
+    skip unless subsecond_precision_supported?
+    string_value = "2017-07-04 14:19:00.5"
+    topic = Topic.create(written_on: string_value)
+    assert_equal topic, Topic.find_by(written_on: string_value)
+  end
+
+  def test_date_time_with_string_value_with_non_iso_format
+    string_value = "04/07/2017 2:19pm"
+    topic = Topic.create(written_on: string_value)
+    assert_equal topic, Topic.find_by(written_on: string_value)
+  end
+end