I have stored datetime in UTC format in databases. I have one
database for each customer. Customers could be all over the US. They
connect to our website, and based on their profile, I know which
timezone they are coming from. Webserver is sitting in Chicago, but
customer could be coming from LA, NY, etc.
When I do .ToLocalTime(), it is converting the time according to
chicago's time, but I need to show the time in LA, NY, etc (depends on
where the customer is coming from).
I am not sure how to achieve this. 8 1465
You need client side time, so your ToLocalTime() should execute as Client
side code, however that is done in ASP or ASP.NET. I think you are executing
a server side code.. I am not a expert in ASP.
VJ
"Sehboo" <Ma*********@gmail.comwrote in message
news:11**********************@y80g2000hsf.googlegr oups.com...
>I have stored datetime in UTC format in databases. I have one
database for each customer. Customers could be all over the US. They
connect to our website, and based on their profile, I know which
timezone they are coming from. Webserver is sitting in Chicago, but
customer could be coming from LA, NY, etc.
When I do .ToLocalTime(), it is converting the time according to
chicago's time, but I need to show the time in LA, NY, etc (depends on
where the customer is coming from).
I am not sure how to achieve this.
Yes, I am writing this in asp.net and C#. This is VS2003.
alright, the you have to execute it on client side.. so I assume you have to
have a clientside script run in your HTML? If I am right?
VJ
"VJ" <no***********@yahoo.comwrote in message
news:Ob**************@TK2MSFTNGP06.phx.gbl...
You need client side time, so your ToLocalTime() should execute as Client
side code, however that is done in ASP or ASP.NET. I think you are
executing a server side code.. I am not a expert in ASP.
VJ
"Sehboo" <Ma*********@gmail.comwrote in message
news:11**********************@y80g2000hsf.googlegr oups.com...
>>I have stored datetime in UTC format in databases. I have one database for each customer. Customers could be all over the US. They connect to our website, and based on their profile, I know which timezone they are coming from. Webserver is sitting in Chicago, but customer could be coming from LA, NY, etc.
When I do .ToLocalTime(), it is converting the time according to chicago's time, but I need to show the time in LA, NY, etc (depends on where the customer is coming from).
I am not sure how to achieve this.
I am not sure how to run asp.net as client side.
you can't, but you can have a client side script in your web page's html,
that does the job for you.
Post in ASP.NET forum you might get a quick trick or tip on that.
VJ
"Sehboo" <Ma*********@gmail.comwrote in message
news:11**********************@n59g2000hsh.googlegr oups.com...
>I am not sure how to run asp.net as client side.
Well that is not goint to work because we have about 100 pages with so
many fields on those pages with date/time. What I have at this point
is that in the guts of the system, I am changin the time to show the
localtime, but that local time is server's time (chicago), and not
NY's time where the customer is coming from.
On Mar 15, 10:44 am, "VJ" <nonewsaddr...@yahoo.comwrote:
you can't, but you can have a client side script in your web page's html,
that does the job for you.
Post in ASP.NET forum you might get a quick trick or tip on that.
VJ
"Sehboo" <MasoodAd...@gmail.comwrote in message
news:11**********************@n59g2000hsh.googlegr oups.com...
I am not sure how to run asp.net as client side.- Hide quoted text -
- Show quoted text -
Other way is if you know in ASP code where the client is coming form, then
write a switch statement do the time translation yourself.. Not the best
way, but may work for you considering the thick of things you are in.
VJ
"Sehboo" <Ma*********@gmail.comwrote in message
news:11**********************@d57g2000hsg.googlegr oups.com...
Well that is not goint to work because we have about 100 pages with so
many fields on those pages with date/time. What I have at this point
is that in the guts of the system, I am changin the time to show the
localtime, but that local time is server's time (chicago), and not
NY's time where the customer is coming from.
On Mar 15, 10:44 am, "VJ" <nonewsaddr...@yahoo.comwrote:
>you can't, but you can have a client side script in your web page's html, that does the job for you.
Post in ASP.NET forum you might get a quick trick or tip on that. VJ
"Sehboo" <MasoodAd...@gmail.comwrote in message
news:11**********************@n59g2000hsh.googleg roups.com...
>I am not sure how to run asp.net as client side.- Hide quoted text -
- Show quoted text -
"VJ" <no***********@yahoo.comwrote in message
news:u5**************@TK2MSFTNGP05.phx.gbl...
Other way is if you know in ASP code where the client is coming form, then
write a switch statement do the time translation yourself.. Not the best
way, but may work for you considering the thick of things you are in.
You can probably store for each client, the time offset from GMT. Then you
won't need ugly switch statements, but a lookup for the client's timezone
and simple date/time arithmetic. GetSystemTimeAsFileTime returns the
current time in a format quite convenient for arithmetic, then you would
convert afterwards to year/month/day style for formatting. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Jason Kinkade |
last post by:
I recently installed MySQL 4.0.18 on my slackware 9.1 machine (kernel
2.4.25) by compiling the source. It works fine, and all tests pass
except one. The timezone test. Can someone tell me why...
|
by: Jim Davis |
last post by:
I'm (still) working on an ISO 8601 date parser. I want to convert at least
the formats described here:
http://www.w3.org/TR/NOTE-datetime
Well.. I've got most of it working (via RegEx's) good...
|
by: cnliou |
last post by:
Hi!
If I correctly understand v7.4 manual, value, say,
'2003-11-26 12:00' in TIMESTAMP WITHOUT TIMEZONE column
should output '2003-11-26 19:00' for "+08:00" timezone.
The following test...
|
by: Raj Chudasama |
last post by:
I have the following code for a clock in my gui.
Everything works fine EXCEPT the following line when the TimeZone is changed
in the windows.
string tz = TimeZone.CurrentTimeZone.StandardName;...
|
by: Bijoy Naick |
last post by:
I have an events table which stores the time of each event - the time and
assoicated timezone. Is there a way of converting this time into GMT (with
support for DST).. some sort of function which...
|
by: David Garamond |
last post by:
When a timestamp string input contains a timezone abbreviation (CDT,
PST, etc), which timezone offset is used? The input date's or today
date's? The result on my computer suggests the latter.
#...
|
by: Bruno Wolff III |
last post by:
Recently there has been some discussion about attaching a timezone to
a timestamp and some other discussion about including a 'day' part
in the interval type. These two features impact each other,...
|
by: asanford |
last post by:
I want to create a web service that allows the caller to pass a DateTime to
the web service (that is, create a web method such as void
MyWebMethod(DateTime dt).) However, I want to be able to...
|
by: Sanjay |
last post by:
Hi All,
Using pytz, I am facing a problem with Asia/Calcutta, described below.
Asia/Calcutta is actually IST, which is GMT + 5:30. But while using
pytz, it was recognized as HMT (GMT + 5:53)....
|
by: =?Utf-8?B?Sm9ubnk=?= |
last post by:
I have an ASP.NET 2.0 C# web application that is contacting an Exchange
server using WEBDAV. It allows the users to look up appointments for a
future date. The problem I have is determining the...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |