Tim Mackey's Weblog
mostly.Net
|
|
Search
Categories
.Net Compact
.Net General
.Net Windows Forms
Asp.Net
Database
General
Mobile
Outdoors
Windows Server 2003
Archive
June, 2010 (2)
May, 2010 (1)
September, 2009 (1)
April, 2009 (1)
March, 2009 (1)
February, 2009 (2)
January, 2009 (1)
December, 2008 (2)
October, 2008 (2)
September, 2008 (1)
August, 2008 (1)
July, 2008 (1)
May, 2008 (2)
April, 2008 (2)
March, 2008 (2)
January, 2008 (4)
December, 2007 (1)
November, 2007 (4)
October, 2007 (3)
September, 2007 (3)
August, 2007 (3)
July, 2007 (5)
June, 2007 (1)
May, 2007 (5)
April, 2007 (4)
March, 2007 (3)
February, 2007 (4)
January, 2007 (3)
December, 2006 (1)
November, 2006 (1)
October, 2006 (3)
September, 2006 (3)
August, 2006 (6)
July, 2006 (2)
April, 2006 (2)
March, 2006 (2)
February, 2006 (4)
January, 2006 (9)
December, 2005 (10)
November, 2005 (3)
October, 2005 (1)
September, 2005 (4)
August, 2005 (6)
June, 2005 (2)
May, 2005 (3)
April, 2005 (3)
March, 2005 (5)
February, 2005 (2)
January, 2005 (3)
December, 2004 (3)
November, 2004 (5)
October, 2004 (3)
September, 2004 (3)
July, 2004 (5)
June, 2004 (3)
May, 2004 (2)
April, 2004 (3)
March, 2004 (7)
Blogroll
Sign In
Thursday, February 22, 2007
HowTo: Get Date Part Only from SQL DateTime value
Thursday, February 22, 2007 5:30:08 PM (GMT Standard Time, UTC+00:00) (
Database
)
CAST(FLOOR(CAST(GetDate() AS FLOAT)) AS SmallDateTime)
Cheers to this
blogger
, he explains why it works.
Comments [0]
| |
Name
E-mail
Home page
Remember Me
Comment (HTML not allowed)
Enter the code shown (prevents robots):
Live Comment Preview