Date and Time Conversion in SQL Server (MSSQL)

Date and Time Conversion in SQL Server (MSSQL)

To get different SQL Server date and time formats, use the following process. It will help in date and time conversion in MSSQL. Use the date format option along with CONVERT function To get YYYY-MM-DD use SELECT CONVERT(varchar, getdate(), 23) To get MM/DD/YYYY use SELECT CONVERT(varchar, getdate(), 1) Check out the chart to get a list of all format options A comprehensive list of formats supported by MSSQL/SQL server are provided below along with example output.  The date used for all of these examples is “2006-12-30 00:38:54.840”. Date Formats Format…

Read More

Top 10 easy to build chatbot platform in 2020

Top 10 easy to build chatbot platform in 2020

My Top 10 List: Top 10 easy to build chatbot platform in 2020 Chatbot platform: It is always recommended to focus on logic over platform to use for fulfilling end user requirements. With increase in demand of chatbot platform in 2019, there are lots of new platforms and even more to come in year 2020 on which you can easily build chat bot. Likewise, I have compiled a list below for your reference. “Whether you are a business owner or a developer or a chat bot enthusiast or looking forward…

Read More

Your First NodeJS App “Hello World”

Your First NodeJS App “Hello World”

My Top 10 List: First NodeJS App “Hello World” Below are the simplest possible steps to create your own first NodeJS app “Hello World”. It is one of the most widely used programming language because of its asynchronous event driven JavaScript runtime built upon Chrome’s V8 JavaScript engine. It not just helps in building scalable network applications but also helps us to make it at ease – which makes it one of the “Human Friendly” development technology. Before we start, asynchronous helps you handle multiple events by allowing you to…

Read More

Reality of HoloLens Microsoft is here…

Reality of HoloLens Microsoft is here…

My Top 10 List: Microsoft HoloLens 2 details HoloLens Microsoft: Microsoft’s amazing launch of HoloLens have created a lot of unanswered questions. HoloLens by Microsoft based on their recent release of HoloLens 2, Microsoft has made mixed reality less awkward. In year 2019, it is still a mystery for a lot of countries to witness existence of such gadget. For starters: HoloLens is a virtual reality (VR) headset with transparent lenses for an augmented reality experience. According to Microsoft, HoloLens is a “fully untethered, see-through holographic computer.” Evolution of User Experience HoloLens gets a drastic…

Read More

Top 10 best wireless headphones under Rs. 2000

Top 10 best wireless headphones under Rs. 2000

My Top 10 List: Top 10 best wireless headphones under Rs. 2000 A lot of people are searching for best wireless headphones at a lower cost. With increase in discounts provided by Amazon, it is always recommended to have a look at wireless headphones on Amazon before making a purchase. Here comes a list of top 10 best wireless headphones compilation that comes under 2000 on Amazon. However, I would recommend you to have a look at other brands if you are inclined towards quality over cost. Other major headphones…

Read More

Top 10 Angular 2 Interview Questions

Top 10 Angular 2 Interview Questions

My Top 10 List: Top 10 Most Popular Angular 2 Interview Questions Angular 2 interview questions: Angular 2 or sometimes referred as AngularJS 2 is an open source JavaScript framework to build web applications in HTML and JavaScript. With increase in demand for Angular 2 applications there is an increase in Angular 2 jobs in the IT industry. There are a lot of companies that are looking for Angular 2 skills, if you are looking at the following things then you are at the right page on the internet: angular 2…

Read More

Top 10 Best Cricket Games

Top 10 Best Cricket Games

My Top 10 List: Top 10 Best Cricket Games With increase in competitive matches and improvement in technology cricket games today arises with a need of top class Cricket Games. Your journey of cricket games google complete with this post which provides a list of best cricket games that are selected based on multiple factors like gameplay, graphics, accessibility, features, player aesthetics and many more. Here is the list of 10 best cricket games to play on a mobile phone. You can go through the below list of cricket games…

Read More

Top 10 python interview questions

Top 10 python interview questions

My Top 10 List: Top 10 interview questions to assess python skills. Python is considered as easy to learn & powerful programming language. Top 10 python interview questions are most asked interview questions which were selected from the years of experience of interviewers. It is one of the most booming technology in the market with increase in forum discussions which got increased by its flexibility. It has efficient high-level data structures and offers simple yet effective approach to object oriented programming. Python is a general purpose and high level programming…

Read More

Top 10 intellectual questions ever asked on Quora

Top 10 intellectual questions ever asked on Quora

My Top 10 List: Top 10 Intellectual Questions ever asked on Quora. There are over 15 million questions asked on Quora…! It certainly boggles my mind that so many people post questions which can be answered in seconds by using Google or some other search engine which creates a need of top 10 list to highlight the intellectual questions ever asked on Quora. However, I keep it for you to judge if Quora is getting overcrowded with unnecessary questions since the inception of free internet service started by the network…

Read More