Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Feb 13, 2013 06:38 AM by anilr499
Feb 13, 2013 05:32 AM|LINK
how to insert a string into a column of data type date
here i need to insert manually 'Last Quarter' into 'week_date' column which is of datatype 'date'
select 'Last Quarter' as week_date , '3.00' as kp,'Blue' as col
select week_date,kpi_tw,CASE WHEN KP > '3' THEN 'Green'
when kp = '3' then 'Blue'
when kp < '3' then 'Red' else 'Orange'
end as col from MU
Conversion failed when converting date and/or time from character string.
Feb 13, 2013 06:12 AM|LINK
use cast(week_date as varchar)
becuase u will not be able to convert 'last quarter' in to date.
on UI u can change accordingly
Feb 13, 2013 06:38 AM|LINK
thank you....i did as u said...:)