I have a smalldatetime field in my SQL database. The SQL format for this is type is : yyyy-mm-dd hh:mm:ss
I need to query my database and request all records where the date matches today's date AND the time portion is 100 minutes from the present time.
Help with the SQL would be greatly appreciated.
You could try something like this
SELECT * FROM TABLE WHERE DateField = CONVERT(smalldatetime,dateadd(MINUTE,100,getdate()),120)