CAST ( LEFT( CAST ("Time"."Yyyymmdd" AS CHARACTER ( 10 )), 4) || '/' || SUBSTRING( CAST ("Time"."Yyyymmdd" AS CHARACTER ( 10 )) FROM 5 FOR 2) || '/' || SUBSTRING( CAST ("Time"."Yyyymmdd" AS CHARACTER ( 10 )) FROM 7 FOR 2) AS DATE )
Where "Time"."Yyyymmdd" is my logical column name of the column that i need to change.
Nice post.
ReplyDeleteIndian Cyber Army’s most awaited internship is live now. Summer Internship 2018 on “ Ethical hacking” and book your seats before it runs out.Candidates have to get themselves registered to be a part of this Internship program. Here internship will give you on-the-job experience, help you learn whether you and Cyber security industry are a good match and can provide you with valuable connections and references. Here interns are usually exposed to a wide variety of tasks and responsibilities which allows the intern to showcase their strengths by working on projects for various managers that work on different parts of Indian Cyber Army. Becoming a high performing intern is a fantastic way to improve your employment prospects. This internship can be a great way to get your foot in the door of success with a prestigious or desirable Organization.As career in ethical hacking is most in demand.