Advertisement

06.03.2008 at 11:03AM PDT, ID: 23454040
[x]
Attachment Details

Ho to add TimeZone (CST ) in datetime column in sql server

Asked by Saroj13 in SQL Server 2005, .Net Editors & IDEs, .NET Framework 2.0

Tags: asp.net, sql server 2005, c#, asp.net, c#, sql server 2005

Hi ,

I have Datetime column in sql server 2005. Currently value looks like "6/3/2008 10:18:45 AM". My webserver is located in acific zone, in that case how to add PST in the "6/3/2008 10:18:45 AM PSt".

When my webserver is in the Central Timezone, how to add "6/3/2008 10:18:45 AM CSt" here.
Please tell  me how i can do that.Start Free Trial
 
Keywords: Ho to add TimeZone (CST ) in dateti…
Title
1 datetime and Timezone
2 Timezone
3 TimeZone
4 How does ASP.NET handle timezones?
5 Dates and Timezones
6 MS CRM - Timezone incorrect - how …
 
Loading Advertisement...
 
[+][-]06.03.2008 at 11:12AM PDT, ID: 21702913

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.03.2008 at 11:20AM PDT, ID: 21702967

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.03.2008 at 11:31AM PDT, ID: 21703075

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.03.2008 at 11:34AM PDT, ID: 21703106

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.03.2008 at 11:34AM PDT, ID: 21703107

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.03.2008 at 11:37AM PDT, ID: 21703150

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.03.2008 at 11:40AM PDT, ID: 21703179

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.03.2008 at 11:42AM PDT, ID: 21703203

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.03.2008 at 02:54PM PDT, ID: 21704948

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: SQL Server 2005, .Net Editors & IDEs, .NET Framework 2.0
Tags: asp.net, sql server 2005, c#, asp.net, c#, sql server 2005
Sign Up Now!
Solution Provided By: jcoehoorn
Participating Experts: 3
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628