Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Feb 26, 2013 08:02 PM by limno
All-Star
117324 Points
8002 Posts
Moderator
MVP
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
All-Star
117324 Points
8002 Posts
Moderator
MVP
Re: Create Date Field
Feb 26, 2013 08:02 PM|LINK
Format your SQL query with instant sql formatter:
http://www.dpriver.com/pp/sqlformat.htm