Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
I am the chief technical officer at InVision App, Inc - a prototyping and collaboration platform for designers, built by designers. I also rock out in JavaScript and ColdFusion 24x7.
Meanwhile on Twitter
Loading latest tweet...
Ben Nadel at Scotch On The Rocks (SOTR) 2011 (Edinburgh) with: Kev McCabe

Mehdi Anis

Member since Dec 11, 2008

Recent Blog Comments By Mehdi Anis

  • Getting Only the Date Part of a Date/Time Stamp in SQL Server

    Posted on Oct 17, 2006 at 4:11 AM

    Ok, I beleive in you :: DATEPART is the Savior. Whatever I do to a DATETIME field, in .NET application it automatically adds 00:00:00 for the time. Ofcourse, we can use client side programming function to convert the DateTime data type to To String() type (From my .NET experience). OR, use DATEPART... read more »

  • Getting Only the Date Part of a Date/Time Stamp in SQL Server

    Posted on Aug 15, 2006 at 11:01 AM

    I am using MS SQL 2005 Server I tried BEN's way and the other 'best' way = CAST(DATEADD(DAY, 0, GETDATE()) AS DATETIME) But none of them works. I am developing a VB .NET application. I think I have to use the .SubString(0, .IndexOf(" ") function to get the DATE only part. It's slow, but haven't... read more »