Create Date Field RSS

• • Reply
  

  limno

  All-Star

  117324 Points

  8002 Posts

  Moderator

  MVP

  Re: Create Date Field

  Feb 26, 2013 08:02 PM|LINK

  --SQL Server 2012
  SELECT Cast(CONCAT (cal_year, '/',  [month], '/', ISNULL(NULLIF(dateday,0),1) ) as date) AS myDate
   FROM yourtableName

  Limno
  
  Format your SQL query with instant sql formatter:
  http://www.dpriver.com/pp/sqlformat.htm