December 5, 2005 at 8:28 pm
I have a classadmit date to from get date() - 24 hours. how to do it TSQl
Thanks
December 5, 2005 at 8:56 pm
= getdate() - 1
_____________
Code for TallyGenerator
December 5, 2005 at 9:44 pm
... or just to be different
DateAdd(hh, -24, GetDate())
--------------------
Colt 45 - the original point and click interface
December 6, 2005 at 7:15 am
Or
DateAdd(minute, -1440, GetDate())
OK, only kidding
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply