skip to main | skip to sidebar

The all purpose blog

Thursday, April 2, 2009

Get Date Without Time

SELECT  CONVERT(DATETIME, FLOOR(CONVERT(FLOAT(24), GETDATE()))) AS OnlyDate
Posted by Mahmad Khoja at 2:14 PM
Labels: Sql Server

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2011 (14)
    • ►  December (2)
    • ►  October (6)
    • ►  September (4)
    • ►  August (1)
    • ►  February (1)
  • ►  2010 (8)
    • ►  April (1)
    • ►  March (5)
    • ►  February (2)
  • ▼  2009 (39)
    • ►  October (8)
    • ►  September (2)
    • ►  August (2)
    • ►  July (2)
    • ►  May (1)
    • ▼  April (5)
      • Disabling Validation On Cancel Buttons Click In As...
      • Open Model Popup Window In JavaScript
      • Magic table in sql server
      • Get Property In Javascript
      • Get Date Without Time
    • ►  March (14)
    • ►  February (4)
    • ►  January (1)
  • ►  2008 (69)
    • ►  December (5)
    • ►  November (8)
    • ►  October (9)
    • ►  September (9)
    • ►  August (38)

About Me

Mahmad Khoja
Khoja Mahmadhusen.A Software Developer (BCA,MscIT,MCP 2.0).
View my complete profile