AshleyRickards
MIS
I'm runnning somer tests on pulling data only on current date and am having some trouble.
In one record the date is like this:
11/30/01 10:00:00 AM
Another with date like:
11/30/01
The staement below returns the second example but not the first.
select * from table1
where [timestamp] = convert(varchar(30), getdate(),101)
What am I missing, besides my sanity?
TIA Ashley L Rickards
SQL DBA
In one record the date is like this:
11/30/01 10:00:00 AM
Another with date like:
11/30/01
The staement below returns the second example but not the first.
select * from table1
where [timestamp] = convert(varchar(30), getdate(),101)
What am I missing, besides my sanity?

TIA Ashley L Rickards
SQL DBA