MSSQL – DATE and <,>

SELECT TOP 5 LEFT(DATEOPEN, 10) FROM tbl_dates  where LEFT(DATEOPEN, 10) < '2021-01-01'

2019-10-16
2011-04-13
2014-06-13
2014-06-18
2012-03-29
2012-03-29

SELECT TOP 5 LEFT(DATEOPEN, 10) FROM tbl_dates where LEFT(DATEOPEN, 10) > '2021-01-01'

2022-05-20
2023-01-11
2022-05-05
2022-12-09
2021-06-21
2021-06-21

This entry was posted on Tuesday, April 8th, 2025 at 10:03 amand is filed under MSSQL Database Development. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.

Comments are closed.