April 27, 2010 at 5:23 pm
How would I use the Datediff to compare changes to a database done from yesterday to today and display results of what was changed?
Retired Navy Chief Petty Officer, Consulting Systems Engineer, C# Programmer, SQL Beginner
April 28, 2010 at 3:24 am
I'm sure you can't use Datediff to do that, if I understand what you're after.
Datediff returns the difference between two dates.
BOL says:
Returns the number of date and time boundaries crossed between two specified dates
-- Gianluca Sartori
April 28, 2010 at 6:07 am
Well you are right then. I cannot use DateDiff for that.
What I need is to be able to compare the changes to the datebase from yesterday or day before to today, and display the results after.
Retired Navy Chief Petty Officer, Consulting Systems Engineer, C# Programmer, SQL Beginner
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply