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 cf.Objective() 2010 (Minneapolis, MN) with: Doug Hughes and Ezra Parker and Dan Wilson and John Mason and Jason Dean and Luis Majano and Mark Mandel and Brian Kotek and Wil Genovese and Rob Brooks-Bilson and Andy Matthews and Simeon Bateman and Ray Camden and Chris Rockett and Joe Bernard and Dan Skaggs and Byron Raines and Barney Boisvert and Simon Free and Steve 'Cutter' Blades and Seth Bienek and Katie Bienek

hrub

Member since Dec 11, 2008

Recent Blog Comments By hrub

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

    Posted on Feb 28, 2007 at 7:58 AM

    try this: (date is 24hr) declare @MyDate datetime set @MyDate = getdate() Select rtrim(datepart(hh, @MyDate)) +'h'+ Case len (datepart(mi, @MyDate)) when 1 then '0' when 2 then '' End + rtrim(datepart(mi, @MyDate)) +'m'+ rtrim(datepart(ss, @MyDate)) +'s' as 'Time'... read more »

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

    Posted on Dec 21, 2006 at 6:51 AM

    hi, How can i write a custom type myDate in sql 2005? -- Create the data type CREATE TYPE myDate FROM base_type,,nvarchar (precision,int,25) allow_null,,NULL I am unsure how to use this. am i looking in the right direction?... read more »