Can i modified time zone in SQL Server 2005 - Support Queries

Welcome Guest

Search | Active Topics | Members | Log In | Register

myLittleTools Community Forum » myLittleBackup for SQL Server (2000, 2005, 2008, 2012) » Support Queries » Can i modified time zone in SQL Server 2005

Can i modified time zone in SQL Server 2005

Options · View

Previous Topic · Next Topic

ak1974

Posted: Tuesday, July 10, 2012 8:51:26 PM

Rank: Newbie
Groups: Member

Joined: 12/19/2011
Posts: -4
Points: 24
Location: Chicago

I am in Chicago which is in Central Daylight Time zone. I am using a Datetime field to submit current date and time, the system using Eastern Daylight Time which is an hour ahead of Chicago time. Is there a way to change the time zone to Central Daylight Time in the databse.

Please response.

Thanks!

elian

Posted: Thursday, July 12, 2012 1:27:43 PM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France

Time Zone must be modified on the server.

Users browsing this topic

Guest

myLittleTools Community Forum » myLittleBackup for SQL Server (2000, 2005, 2008, 2012) » Support Queries » Can i modified time zone in SQL Server 2005

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.