Forum Replies Created
Viewing 4 posts - 1 through 4 (of 4 total)
-
RE: Remove time part from datetime column
Tom Goltl (11/21/2006)
-- Returns Date Portion Only
dateadd(d, 0, datediff(d, 0, getdate())) As DateOnly
That SQL was just what I was looking for. Thanks Tom! 🙂
-
RE: Checking for a character
Just to say that I found Jonathan Stokes code very useful. Thanks!
-
RE: Error "Arithmetic overflow error converting expression to data type datetime."
Hi Frank,
Thanks for the link. Very interesting!
Mike
-
RE: Error "Arithmetic overflow error converting expression to data type datetime."
Hi Julian,
I was having a similar problem updating a datetime field in a trigger. Was trying to stuff the date in as dd/mm/yyyy when it should have been mm/dd/yyyy. It...
Viewing 4 posts - 1 through 4 (of 4 total)