Date Conversion formats in SQL Server

SQL Server supports different options to format Date/Time string.

Date Convert Format	Result
CONVERT(VARCHAR(50), GETDATE(), 100)	Oct 10 2018 4:28AM
CONVERT(VARCHAR(50), GETDATE(), 101)	10/10/2018
CONVERT(VARCHAR(50), GETDATE(), 102)	2018.10.10
CONVERT(VARCHAR(50), GETDATE(), 103)	10/10/2018
CONVERT(VARCHAR(50), GETDATE(), 104)	10.10.2018
CONVERT(VARCHAR(50), GETDATE(), 105)	10-10-2018
CONVERT(VARCHAR(50), GETDATE(), 106)	10 Oct 2018
CONVERT(VARCHAR(50), GETDATE(), 107)	Oct 10, 2018
CONVERT(VARCHAR(50), GETDATE(), 108)	04:28:25
CONVERT(VARCHAR(50), GETDATE(), 109)	Oct 10 2018 4:28:25:467AM
CONVERT(VARCHAR(50), GETDATE(), 110)	10-10-2018
CONVERT(VARCHAR(50), GETDATE(), 111)	2018/10/10
CONVERT(VARCHAR(50), GETDATE(), 112)	20181010
CONVERT(VARCHAR(50), GETDATE(), 113)	10 Oct 2018 04:28:25:467
CONVERT(VARCHAR(50), GETDATE(), 114)	04:28:25:467
CONVERT(VARCHAR(50), GETDATE(), 120)	2018-10-10 04:28:25
CONVERT(VARCHAR(50), GETDATE(), 121)	2018-10-10 04:28:25.467
CONVERT(VARCHAR(50), GETDATE(), 126)	2018-10-10T04:28:25.467
CONVERT(VARCHAR(50), GETDATE(), 127)	2018-10-10T04:28:25.467
CONVERT(VARCHAR(50), GETDATE(), 130)	30 ???? 1440 4:28:25:467AM
CONVERT(VARCHAR(50), GETDATE(), 131)	30/01/1440 4:28:25:467AM

Comments

Javascript - Unanswered questions - Part 1

What is Event delegation? Event delegation is Javascript as it relates to the DOM. It basically means that if you attach an event listener to a DOM element that listener is not only firing on that DOM element. It's actually firing on every children in that. So, for instance if you have a navigation and so you've got an unordered list you've got list items and then you've got anchor tags inside that navigation what you have. If you add an event listener to the ul element in essence you're actually adding event listener to all of the children as well. In short, JS event listeners fir not only on a single DOM element but on all its descendants. What is Event Bubbling? It's actually inverse of Event delegation. Also known as propagation, events on an DOM element will bubble up and also fire on all parents. What's the difference between "target" and "currentTarget"? target is the actual element that triggered the event for example clicked, wh...

Microservices vs. APIs

It still surprises me just how many times I come across misconceptions around Micro Services and APIs. Often hearing phrases like micro services are fine grained web services or API is themselves are equivalent to micro services. These all sort of show fundamental misconceptions under the covers. So, I've written this just to really break that out and explain about what the key differences are in those two concepts. What is an API? An API, fundamentally Application Programming Interface, that is an interface. It's a way of making requests into a component. So it's the route that you go in to make those requests. In modern use that typically means a REST API, that's a call made using HTTP protocol using JSON data as the payload. What are Micro Services? So let's ensure we also have a clear crisp definition on what a micro service architecture really is. Micro-Services architecture is about breaking down large silo applications into smalle...

LOGANATHAN VELSAMY

Search This Blog