Community Member Profile
bbn911
Member since Jul 16, 2009
- Profile: /members/3831-bbn911.htm
- Comments: 1
- Points: 10
Recent Blog Comments By bbn911
-
Getting Only the Date Part of a Date/Time Stamp in SQL Server
Posted on Jul 16, 2009 at 5:08 PM
here is another option - should be faster... ALTER FUNCTION [dbo].[GetDateOnly] ( @DateToFix DateTime ) RETURNS DateTime AS BEGIN DECLARE @dateMask bigint DECLARE @timeMask bigint SET @dateMask = 0xffffffffff000000 SET @timeMask = 0x000... read more »
