`Select` trigger returns incorrect records based on timestamp

[HannaTrotsenko]

Component Bug Report

Description

Credentials https://vault.bitwarden.com/#/vault?search=Data&itemId=68362483-5aba-4924-91ea-aaca00e449ec&action=view

Component Version

v2.5.10
Database: MySQL, MSSQL, postgreSQL, Oracle

Steps to Reproduce

1. Create new flow, select JDBC component Select trigger
2. SQL Query ->>> select * from employee
3. Start Polling From (optional) ->>> 2025-11-11 08:30:00
4. Retrive sample
5. Pay attention to the field last_login field in the sample's json or hire_date (because we don't know which field it uses for timestamp)

Actual Result

e.g.

{
  "employee_id": 8,
  "first_name": "Iryna",
  "last_name": "Savchuk",
  "email": "i.savchuk@corp.com",
  "hire_date": "2023-10-25",
  "salary": 51000,
  "is_active": false,
  "department": "Marketing",
  "notes": "Currently on maternity leave.",
  "last_login": "2023-10-24 16:00:00.0"
}

Expected Result

If record in DB has date/time field it should respect the value from Start Polling From field to poll the records

Workaround(s)

no