Date Function

Question

Create a field in Table Colum:- tbl_inst_install_date Data Type -----varchar(50) Date 03/02/2016

No, I want to Convert this Colum Date from 03/02/2016 to 2016 (dd/mm/yyyy) To (YYYY)

Kindly Advise us

Answer 1

Hi @SAQ ,

Welcome to Microsoft Q&A!

Please refer below:

select year(cast(yourcolumn as date)) from yourtable  

select format(cast(yourcolumn as date),'yyyy') from yourtable  

select  right(yourcolumn,4) from yourtable  

Best regards,
Melissa

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.