Function TestTypesDateTime

tests/integration/types_test.go:80–122

TestTypesDateTime tests date/time type handling

(t *testing.T)

// TestTypesDateTime tests date/time type handling
func TestTypesDateTime(t *testing.T) {
	tests := []QueryTest{
		// Date
		{Name: "date_literal", Query: "SELECT DATE '2024-01-15'"},
		{Name: "date_cast", Query: "SELECT '2024-01-15'::DATE"},
		{Name: "date_far_future_sentinel", Query: "SELECT DATE '9999-12-31'"},
		{Name: "date_positive_infinity", Query: "SELECT DATE 'infinity'"},
		{Name: "date_negative_infinity", Query: "SELECT DATE '-infinity'"},
		{Name: "current_date", Query: "SELECT CURRENT_DATE IS NOT NULL"},

		// Time
		{Name: "time_literal", Query: "SELECT TIME '12:30:45'"},
		{Name: "time_cast", Query: "SELECT '12:30:45'::TIME"},
		{Name: "time_with_microseconds", Query: "SELECT TIME '12:30:45.123456'"},

		// Timestamp
		{Name: "timestamp_literal", Query: "SELECT TIMESTAMP '2024-01-15 12:30:45'"},
		{Name: "timestamp_cast", Query: "SELECT '2024-01-15 12:30:45'::TIMESTAMP"},
		{Name: "timestamp_with_microseconds", Query: "SELECT TIMESTAMP '2024-01-15 12:30:45.123456'"},

		// Timestamp with timezone
		{Name: "timestamptz_literal", Query: "SELECT TIMESTAMPTZ '2024-01-15 12:30:45+00'"},
		{Name: "timestamptz_cast", Query: "SELECT '2024-01-15 12:30:45+00'::TIMESTAMPTZ"},
		{Name: "now_function", Query: "SELECT NOW() IS NOT NULL"},

		// Interval
		{Name: "interval_day", Query: "SELECT INTERVAL '1 day'"},
		{Name: "interval_hour_minute", Query: "SELECT INTERVAL '1 hour 30 minutes'"},
		{Name: "interval_complex", Query: "SELECT INTERVAL '1 year 2 months 3 days'"},
		{Name: "interval_cast", Query: "SELECT '1 day'::INTERVAL"},

		// Date arithmetic
		{Name: "date_add_interval", Query: "SELECT DATE '2024-01-15' + INTERVAL '1 month'"},
		{Name: "date_subtract_interval", Query: "SELECT DATE '2024-01-15' - INTERVAL '1 day'"},
		{Name: "date_add_integer", Query: "SELECT DATE '2024-01-15' + 7"},
		{Name: "date_difference", Query: "SELECT DATE '2024-01-15' - DATE '2024-01-01'"},

		// From table
		{Name: "select_date_column", Query: "SELECT date_col FROM types_test WHERE id = 1"},
		{Name: "select_time_column", Query: "SELECT time_col FROM types_test WHERE id = 1"},
		{Name: "select_timestamp_column", Query: "SELECT timestamp_col FROM types_test WHERE id = 1"},
		{Name: "select_timestamptz_column", Query: "SELECT timestamptz_col FROM types_test WHERE id = 1"},
		{Name: "select_interval_column", Query: "SELECT interval_col FROM types_test WHERE id = 1"},
	}
	runQueryTests(t, tests)
}