How to compare time in SQL?

select datediff(day, (select from table where id=1 )

getdate())

select from table where id=1 ) is the time extracted from the database, re-customize.

getdate() is today's date.

The overall is the difference between the time it was extracted from the database and the present day.

If you want to compare the time in the database and the database, write it again as described above.

It's not that troublesome, just use the greater than less than sign.

** Ideas:

The difference in seconds between two times, when equal to 0, means that the two dates are the same.

getdate() indicates the current system time of the fant.

select datediff(second,'2012-12-15 16:54:00',getdate())

** Ideas:

The difference in seconds between two times, when equal to 0, means that the two dates are the same.

getdate() indicates that the current system time is obtained.

select datediff(second,'2012-12-15 16:54:00',getdate())

If the difference between the two times is equal to 0, the two dates are the same, and getdate() indicates that the current system time is obtained.

select datediff(second,'2012-12-15 16:54:00',getdate())

Whether the current time is the same as the specified time.

oracle

where sysdate = specified time for sql server

where getdate() = specified timeNote: Due to accuracy issues, it is a bit difficult to make sure that the current time matches the specified time to seconds, or even three hundredths of a second.

compare:import;

For example, today is 2010-12-2

date d1 = new date(;

date d2 = new date(;On a date 1 ms later than d1, we consider d1 and d2 to be equal.

But; The output is true;

What we want to see is that the two objects are equal in date.

Because we only care about the "date", and "2010-12-2" is not the same as "2010-12-2".

This result is clearly unacceptable to us.

The reason for this is that the date encapsulates a private transient long fasttime that is accurate to the millisecond;

The implementation of the before and after functions is as follows, both of which determine the value of fasttime, so it does not meet our requirement of only comparing dates.

Public Boolean Before(Date When)Public Boolean After(Date When) format the date as a standard "year, month, day", and then compare the formatted objects to get the comparison result.

This article gives a way to "standardize formatting".

date d1_temp = ;

date d2_temp = ;

The output is true;

The output is false;

The output is false;

If you need logic, you can write it.

if(d1_

date date = new date();

date date1 = new date();

Determine whether it is before date1.

Determine whether it is after date1.

It's as simple as that, and the data returned is Boolean.