Skip to main content

Posts

Showing posts with the label Convert String DateTime to DateTime in SQL Server?

71 Best MongoDB Interview Questions and Answers - [MongoDB]

“ MongoDB   is the fastest growing database because it’s provided more security protection mechanisms than others and also more reliable in cloud computing environments. It is secure architecture for your deployment”. It is document oriented database and its store the data in document with   JSON  format. Most Popular 71 Key Questions for MongoDB Interviews. What is MongoDB and Why we use? What's New in MongoDB 3.2? Is MongoDB Support Relationship? Is MongoDB Support Replication? What are journaling in MongoDB? What kind of database is MongoDB? In MongoDB, What is a namespace? In which language MongoDB is written? Do MongoDB databases have tables and schemas? What types of languages use to work with MongoDB? Which are the most powerful features in MongoDB? ...

Convert String DateTime to DateTime in SQL Server?

Hello everyone, I am going to share the query sample for convert string date-time to date-time and also use of various types of convert in SQL .                        Table of Contents 1.        Query for convert string DateTime to DateTime type 2.        Query for convert GETDATE to DATE type 3.        Query for convert GETDATE to string DATE type 4.        Query for convert GETDATE to DateTime type 5.        Query for convert GETDATE to string DateTime type 6.        Query for convert GETDATE to string dateTime2 type The Query detail as given below. DECLARE @DATEIME DATETIME = '10/01/2016 12:25pm'     SELECT CONVERT ( DATETIME , @DATEIME ) as DAT...