In one of my SQL Server tables, I have te following rows:

I'd like to get rows that start from a specific Date, and then from a specific Time. For instance, passing 2021-10-02 and 12:00:00.0000000, I'd like to get the last four rows because 2021-10-02 is considered the "starting date", and then 12:00:00.0000000 is considered the "starting time". Unfortunately, I'm not so good at SQL. I guess nested queries should be the way to go.

CodePudding user response：

You'll need to be a little "2 pronged" about this. You'll need to check the date is on 2021-10-02 and on or after 12:00:00.0000000, or on or after 2021-10-03:

SELECT {YourColumns}
FROM dbo.YourTable
WHERE (YourDate = '20210102' AND YourTime >= '12:00:00')
   OR YourDate >= '20210103';