.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Convert ServerTime to purticuler Time Zone

Posted By:      Posted Date: August 27, 2010    Points: 0   Category :ASP.Net


how to convert server time to a purticuler TimeZone


View Complete Post

More Related Resource Links

How do I convert UTC to specified time zone in T-SQL (SQL Server 2008 R2)?


Question: How do I convert UTC time to specified time zone using SQL in SQL Server 2008 R2?


Scenario: I have a database/ASP.NET application that I use to manage people from quite a few different time zones. In order to keep activities coordinated, all the times in the database are UTC time. Each user's TimeZone is also registered in the database using .NET Framework time zoneIDs e.g. Eastern Standard Time.

In my query I want to specify a date and pull all the activities for that date. However, because all time stamps are UTC times, sometimes an individual's activies fall on two consecutive days in UTC time zone even though the individual completed them on the same day in his/her time zone. As a result, I get misleading data.

When I specify a date, I want that date to be considered user's date. That means, I need to convert all the activity time stamps into user's time zone in my query. This is where I can use some help.

Thanks, Sam

time zone


Hi all,
I have hosted a retail web application in Godaddy, how to pick particular country time in asp.net.
Thanks in advance.
J Walia

Hi all,

I have hosted a retail web application in Godaddy, how to pick particular country time in asp.net.

Thanks in advance.

J Walia

Convert Update Date/Time to VB.NET



I was wondering if someone could convert this into VB.NET for me.  I'm not a PHP pro and not entirely sure what's happening here nor do I know how to get this to display the same way.

The new field is within a DetailsView, so you can give me example code as well, I'll greatly appreciate it.

Thanks.. -Jeff

PHP Code:

function updFormat($tStamp) {
	$tsTime = (strftime('%I', $tStamp) + 0) . strftime(':%M %p', $tStamp);
	// 86400 == # of seconds in a day
	$tsDays = floor($tStamp / 86400);
	$nowDays = floor(time() / 86400);
	if ($tsDays == $nowDays) $updTime = "Today at $tsTime";
	elseif ($tsDays == $nowDays - 1) $updTime = "Yesterday at $tsTime";
	else $updTime = strftime('%b ', $tStamp) . (strftime('%d', $tStamp) + 0) . strftime(', %Y' , $tStamp);

	return $updTime;
<asp:DetailsView ID="dtv_LastUpdated" runat="server" Width="100%" 
    AutoGenerateRows="False" DataSourceID="ods_MVPParcelUpdate" 
    CellPadding="1" CellSpacing="1" GridLines="None">
        <asp:BoundField DataField="Update_time" HeaderText="Parcel Data:" 

how can i convert Persian date to c# date time?

hi all how can i convert Persian date to c# date time? Persian Date like 1388/01/20 Thanks Motevallizadeh

Convert the Sql query to LINQ .. can anyone please help me I need it ASAP as no time to learn and im

 SELECT DISTINCT HP.PartNumber, HP.MIRevision, HPEXData.InstructionImage, EXAttr.PlacementImage from dbo.HardwareParts HP   INNER JOIN dbo.HardwarePartEXData HPEXData     ON HP.HardwarePartID = HPEXData.HardwarePartID   LEFT JOIN dbo.EXMIAttributes EXAttr    ON EXAttr.EXTypeID = HPEXData.EXTypeID   WHERE    HP.PartNumber = @PartNumber     AND REPLACE(SUBSTRING(HP.MIRevision, 1, 13),'.','') >= REPLACE(SUBSTRING(ISNULL(@PartRevision,''), 1, 13),'.','')    AND ISNULL(HP.ProjectID,'') = ISNULL(@SINumber,'')    AND (@ChassisIdentifier IS NULL OR HPEXData.EXMI_Type NOT IN ('Add In Card','Storage') OR EXAttr.ChassisIdentifier = @ChassisIdentifier)   END;anji

Convert a string (from xml) into date time

Is there a simple command to take this string: 2010-09-09T17:00:00.000Z and turn it into a date time? It is a date time value that is passed to us in an xml document, it has a type of 'unitless', when I read it I need to set a dateTime variable to this date and tim, I can parse it, but perhaps there is a simple single command that is already written for just such a thing. Thanks. 

Get time value after "." and convert


I have a field that has time value = 2010-10-15T01-16-17.000Z


Now this value can differ in seconds and can be in different formats like these






What I want to do is : I want to get the no. of digits after .(dot) and convert it into the correct zulu format


So I wrote the following code


    Dim getTime As String = myTime.Substring(myTime.IndexOf(".") + 1, myTime.Length - myTime.IndexOf(".") - 1)


   Dim Receiveddate As String


If getTime.Length = 2 Then

                                                    Receiveddate = rectime.ToUniversalTime().ToString("yyyy-MM-ddTHH:mm:ss.fZ")


mysql time zone



   i have changed the srver time zone to +05.30 but mysql timezone is not  changing it's time zone according to the system time ...... so please help me to change the mysql timzone.............

Convert time to military time



I have a datetime column in my table.  It has a value like this for example: 4/27/2010 7:34:00 PM.  I would like to display the time part of the column in military time.  So this datetime column would appear as: 4/27/2010 19:34

Is this possible?





Unable to convert MySQL date/time value to System.DateTime



I get the following error when i call my method from the class any ideas?

Unable to convert MySQL date/time value to System.DateTime

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: MySql.Data.Types.MySqlConversionException: Unable to convert MySQL date/time value to System.DateTime

Source Error:

Line 324:        string strqry = "Select * FROM tblclients";
Line 325:
Line 326: DataTable returnDatatbl = conClass.queryDB(strqry);
Line 327:
Line 328:

How can I provide the user with the option to select or default their time zone when rendering a cal

Dallas-based and Tokyo-based users both have contributor access to a shared site calendar. Tokyo users would like to view their calendar items based on their time zone and Dallas would like to see the calendar items based on Dallas time zone. When a Tokyo user enters an event on the calendar their time, e.g. Sunday 11/28/10 holiday, it shows as a Monday, 11/29/10 holiday. The MOSS 2007 Enterprise w/ WSS 3.0 servers reside in Dallas. What options do we have to render the time zone based on user view or accurately reflect the date of the event for the originating time zone?

Time Zone Inconsistancies


We are using InfoPath with SharePoint and have mapped some form fields to metadata fields.  We have offices around the globe.  When people from different offices make small changes on an InfoPath form, the dates get clobbered.  It appears that the date is translated based on the user's time zone when the form is open for reading, but the raw [now translated] date gets written back to SharePoint even when they do not touch the date.  Needless to say, after a number of people from different offices touch a form the dates end up with very unpredictable values.

Is it possible to use InfoPath with SharePoint in a global setting?  We have really racked our brains trying to build work arounds to this bug.  I have seen other posts that suggest we create a site for each time zone.  While this might solve the time zone translation issues, it totally disrupts the collaborative process.

Any ideas are greatly appreciated.

Confirm/Update people's time zone settings


I need to confirm each user's time zone settings.  How do I run a report to confirm each user's time zone settings.  Additionally, I need to update the user accounts that are set incorrectly. 

I have found numerous posts on the web that suggest I have each individual do this for themselves or to site down with each user and set this up while they are logged in, but these are absolutely insane suggestions, so please share with me how this is support to be done.

Round off time to the nearest minute

How would you round this up to the nearest minute? There isn't a built in function to do this so you have to use a little bit of maths to get there. There are 60 seconds in a minute. We already have 38 seconds on the clock. So we need to add on 60 - 38 = 22 more seconds.

Performance Tests: Precise Run Time Measurements with System.Diagnostics.Stopwatch

Everybody who does performance optimization stumbles sooner or later over the Stopwatch class in the System.Diagnostics namespace. And everybody has noticed that the measurements of the same function on the same computer can differ 25% -30% in run time. This article shows how single threaded test programs must be designed to get an accuracy of 0.1% - 0.2% out of the Stopwatch class. With this accuracy, algorithms can be tested and compared.

Date and Time Functions in SQLSERVER

Date and time functions allow you to manipulate columns and variables with DATETIME and SMALLDATETIME data types.

1 DATEPART Function
2 DATENAME Function
3 DAY, MONTH, and YEAR Functions
5 DATEADD Functions
6 DATEDIFF Function
7 More SQL Server Functions

Data Types - Date and Time in SqlServer

Date and time values can be stored with either the DATETIME or SMALLDATETIME data type. The difference between the two is that SMALLDATETIME supports a smaller range of dates and does not give the same level of precision when accounting for time. The DATETIME data type can hold values from January 1st of 1753 to December 31st of 9999. The time is stored to the 1 three hundredths of a second and each value takes up 8 bytes of storage. The SMALLDATETIME data type can hold values between January 1st 1900 and June 6th of 2079. The time is tracked to the minute and each value takes up 4 bytes of storage. The majority of business applications can live happily with SMALLDATETIME, however, if you are in an environment where each second matters or you need to make estimates to the distant future (or past) then you have to resort to DATETIME. If you fail to specify the time when inserting a value into a DATETIME or SMALLDATETIME column, a default of midnight is used. If you fail to specify the date portion the default of January 1, 1900 is used.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend