Community Member Profile

Andrew
Member since Dec 11, 2008

Recent Blog Comments By Andrew

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

    Posted on Apr 2, 2007 at 2:20 PM

    Garth had it right, at least with SQL Server. You don't need a custom function to do what's already built in. If you need to use it in a comparison you can easily do something like WHERE CONVERT(nvarchar(20), MyDateColumn, 101) BETWEEN @DateFrom AND @DateTo I always forget the... read more »

Member Account Kinky Solutions Shop
  • Help Wanted - Find Your Next ColdFusion Job
InVision App - Prototyping Made Beautiful With Prototyping Tools