Community Member Profile

Recent Blog Comments By Girish

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

  Posted on Aug 5, 2010 at 4:46 AM

  @keth, One option is to split it as follows. <% response.write(MonthName(month(date()))&" "&day(date())&","&year(date())) %>... read more »

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

  Posted on Feb 1, 2008 at 12:22 AM

  I have another simple solution for separating out time from the datetime stamp. convert(datetime,( convert(varchar (11),getDate())))... read more »