Convert string to DateTime format in SQL Server

Question

How to Convert date formatDate is 20190101i am passing it to Stored Procedurei want this date to be save into table in 20190911 000000000 Format how to achieve this

dharmendr · Accepted Answer

Hi chetanUse Convert function to insertSELECT CONVERTDATETIME392019091139101

ArnoldDol · Answer

First created a new table named testtimestamp that has a TIMESTAMP column t1CREATE TABLE testtimestamp     t1  TIMESTAMPSecond set the sessionrsquos time zone to lsquo0000rsquo UTC by using the SET timezone statementSET timezone0000Third insert a TIMESTAMP value into the testtimestamp table INSERT INTO testtimestampt1 VALUES3920080101 00000139Fourth select the TIMESTAMP value from the testtimestamp tableSELECT t1 FROM testtimestampFifth set the sessionrsquos time zone to a different time zone to see what value we will get from the database serverSET timezone 0300Finally query data from the tableSELECT t1 FROM testtimestampMySQL Timestamp timezone changesAs you see we received a different time value adjusted to the new time zone

Convert string to DateTime format in SQL Server

Company

Explore

Follow us

Contact Us