EdwardPeter
asked on
query present day
Hi,
Kindly assist how can we query the data for present day? select * from table1 where DTstart between getdate() and getdate() + 23:59:59
Thanks.
Kindly assist how can we query the data for present day? select * from table1 where DTstart between getdate() and getdate() + 23:59:59
Thanks.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
u want the records where dates between today and tomorrow, IF IT IS SO
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>> Or more elegantly
more ? for sure? :)
more ? for sure? :)
ill, snidey comments hurt
oh by the way
dateadd( ss, 86400, convert( varchar(8), getdate(), 112 )) will return entries for the first second of the next day
oh by the way
dateadd( ss, 86400, convert( varchar(8), getdate(), 112 )) will return entries for the first second of the next day
what "snidey" means? i'm not from english speaking country.
keep smiley-ing ;)
keep smiley-ing ;)