python ruby-programming-language Smalltalk Vue.js Knockoutjs TypeScript JavaScript, OOPs JavaScript Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 4 Angular 2 AngularJs 1.x NodeJs Perl Programming R Programming RequireJs Rust Programming Backbonejs closure programming language go-programming-language kotlin-programming-language
Convert String DateTime to DateTime in SQL Server?

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 DATETIME


SELECT CONVERT (DATE, GETDATE()) as Date
SELECT CONVERT(VARCHAR(10), GETDATE(), 113) as Date

SELECT CONVERT (DATETIME, GETDATE()) as DateTime
SELECT CONVERT (DATETIME2, GETDATE()) as DateTime2

SELECT CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 112)) as DateTime


The output as given below image



ANIL SINGH

Hi there! Welcome to my blog. My name is Anil Singh. I'm a author of this blog. For more detail about me, kindly refer to this link..
My Blogs - http://code-sample.com and http://code-sample.xyz
My Books - Interview Questions and Answers Books- Get Your Book in 15+ Digital Stores Worldwide..

You Might Also Like
www.code-sample.com/. Powered by Blogger.
ASK Questions