How to Change Date Time

Posted by Jayakumars under ASP.NET AJAX on 12/16/2016 | Points: 10 | Views : 1488 | Status : [Member] [MVP] | Replies : 2
Hi

How to change Date and Time in Sql server Management Studio in Sql server 2014 Version.

I tried to changed via control panel datetime after i come open sql server management studio windows . But my Datetime not changed . How to change this any one guide me.

Mark as Answer if its helpful to you

Kumaraspcode2009@gmail.com



Responses

Posted by: Sheonarayan on: 12/16/2016 [Administrator] HonoraryPlatinum | Points: 25

Up
0
Down
You want to change the date and time of the system or the format of the date time in SQL Server?

SQL Server takes the date time of the machine on which it is installed and it stores the datetime in yyyy-MM-dd hh:mm:ss format (in general).

If you want to convert into other format or take only a particular value of the datetime then you can use DatePart or DateName function as shown here http://techfunda.com/howto/434/datepart-function.

Hope thishelps, Thanks

Regards,
Sheo Narayan
http://www.dotnetfunda.com

Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jayakumars on: 12/16/2016 [Member] [MVP] Bronze | Points: 25

Up
0
Down
Hi
Sheo


I want to change the date and time in SQL Server

How will do this ?

For ex: I can change date time in control panel for ex: this

Date : 25 Dec 2016
Time : 10:00:00

But after i go to sql server but date and time noting changed in sql server

no need datepart query sheo. i need change date time in sql server only

thanks for your response

Mark as Answer if its helpful to you

Kumaraspcode2009@gmail.com

Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response