Hi,
If a server is physically localled in CST and is shared, how can one create
a Web Application on that server that has its timezone for EST???
I've seen other threads in this group that talk about using UTC/GMT and also
getTimezoneOffs et(), but in this case, the business rules are such that the
Web App be based upon the time zone that the physical business is located.
TIA,
geo
2  4069 
you have to standardize somehow. there are couple options.
1) store both datetime and timezone always.
2) store datatime and offset from gmt
3) store all datetimes in starndard zone, say gmt
you business layer should convert all datetime what standard you pick. this
means entry/display datetimes require specification of the timezone or
offset form stabdard. you can default this for the website or user.
-- bruce (sqlwork.com)
"Dotnet Gruven" <do**********@n ewsgroup.nospam > wrote in message
news:%2******** ********@TK2MSF TNGP10.phx.gbl. .. Hi,
If a server is physically localled in CST and is shared, how can one
create a Web Application on that server that has its timezone for EST???
I've seen other threads in this group that talk about using UTC/GMT and
also getTimezoneOffs et(), but in this case, the business rules are such
that the Web App be based upon the time zone that the physical business is
located.
TIA,
geo
This issue is one of the most grievous flaws in the framework that has been
present since 1.0. Dates and times would be so easy to work with if all
system time was offset from Greenwich using an appropriate attribute value
set in a web.config file.
<%= Clinton Gallagher
NET csgallagher AT metromilwaukee. com
URL http://clintongallagher.metromilwaukee.com/
"Bruce Barker" <br************ ******@safeco.c om> wrote in message
news:%2******** ********@TK2MSF TNGP10.phx.gbl. .. you have to standardize somehow. there are couple options.
1) store both datetime and timezone always.
2) store datatime and offset from gmt
3) store all datetimes in starndard zone, say gmt
you business layer should convert all datetime what standard you pick.
this means entry/display datetimes require specification of the timezone
or offset form stabdard. you can default this for the website or user.
-- bruce (sqlwork.com)
"Dotnet Gruven" <do**********@n ewsgroup.nospam > wrote in message
news:%2******** ********@TK2MSF TNGP10.phx.gbl. .. Hi,
If a server is physically localled in CST and is shared, how can one
create a Web Application on that server that has its timezone for EST???
I've seen other threads in this group that talk about using UTC/GMT and
also getTimezoneOffs et(), but in this case, the business rules are such
that the Web App be based upon the time zone that the physical business
is located.
TIA,
geo
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 I'm getting
this error? Is there something with the TZ variable I have to set for
the shell? I think its EDT right now.
timezone
Errors are (from /custompath/mysql/mysql-test/var/log/mysqltest-time)
|
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 enough for me but I'm
having a brain block when it comes to TimeZone.
The datetime may come with an optional timezone offset (from GMT) as here
(the offset is +1 hour from GMT):
|
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 results seem to be somewhat unexpected.
Restting OS timezone (/etc/timezone and /etc/localtime in
Linux) does not make the results more comfortable.
|
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;
It will not pick the changed timezone
but it does pick up time change due to timezone change.
|
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 accepts a time and timezone
as parameters and returns the time in GMT?
| | |
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.
# create table ts (ts timestamptz);
# insert into ts values ('2004-10-17 00:00:00 CDT'); -- UTC-5
# insert into ts values ('2004-11-17 00:00:00 CDT'); -- UTC-6
# select ts at time zone 'utc' from ts;
timezone
---------------------
|
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, since
if you add a 'day' to a timestamp the result can depend on what timezone
the timestamp is supposed to be in. It probably makes more sense to use
a timezone associated with the timestamp than say the timezone GUC or the
fixed timezone UTC.
...
|
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 capture the
TimeZone of the caller as well - but I don't want the interface to specify an
xs:string as the method argument - I want it to use an xs:dateTime type
argument.
Now, I know when a DateTime structure is serialized into XML it becomes an...
|
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). While I digged into the
oslan database, I see the following:
# Zone NAME GMTOFF RULES FORMAT
Zone Asia/Calcutta 5:53:28 - LMT 1880 # Kolkata
|
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 correct client time zone.
Note that Exchange stores everything in UTC time.
I am able currently able to use javascript to ask the client what time zone
they are in, but this is only for the "today" (the current day) and not for a
day in the...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
