How to Change Date Format with Convert in Sql

Jayakumars
Posted by Jayakumars under Sql Server category on | Points: 40 | Views : 842
hi
I have post the Query .How to Change Date Format with Convert in Sql

Select GetDate()-2
Select convert(varchar(12),GetDate()-2,101) Format MM/DD/YYYY
Select convert(varchar(12),GetDate()-2,103) Format DD/MM/YYYY

Comments or Responses

Login to post response