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 CFUNITED 2008 (Washington, D.C.) with:

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 »