How to Change Date Format with Convert in Sql

Posted by Jayakumars under Sql Server category on 3/26/2013 | Points: 40 | Views : 1342

Post Code |

Search Codes |

Code Home

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

Alert Moderator

Bookmark It

Comments or Responses

Latest Code Snipptes

Azure Function - Connect to MS Dynamics using application user - .NET core 3.1
MS Dynamics 365- Custom action - Read input parameter values from plugin
MS Dynamics 365- Disassociate record from N-N relationship entity
Search box with icon in Navbar in bootstrap 4
Remove HTML tags using Regular Expression in C#
MS Dynamics 365- Close Quote from C# / Custom action
How to show and hide submenu in tabs using jquery
How to add star rating and submit rating
MS Dynamics 365 - Create an email activity using dynamics crm Rest API - C#
More ...