I have the code:
[Code]....
[Code]....
I live in Saint-Petersburg, so s="11 : 15 : 14". What should i write in web.config or in some else place for take the similar hours?
I can't to use ToString, ToUniversalTime and change Parse arguments (it data takes from web services).
I'm having an issue working out how to implement this time based event. Basically, my program needs to send out an email at 12AM monday morning. But the email needs to go based on the user's local time not 12AM server time.
the problem i have discovered is Daylight savings. I used current server time as 12:00AM (my local time) and my actual offset is -7:00 UTC but after the calculation i get -6:00 utc because of daylight savings. If a user was in -7:00UTC then he/she will not get the email at 12am localtime but an hour late.
I am trying to create an app which shows current time in 6 time zones (Sydney, S'pore, india, london, EST and CST).
I am having troubles handling DST, because DST starts and ends on different dates in different countries.
More over I want to make it configurable (add/remove cities from the list).
Currently I have added the cities in .config with their timezone differences (with respect to GMT).
[code]....
I got this answer from Kjensen and read the answers, but this is a different webapp
I'm running scheduled events that process incoming orders, set Picking material, manage Track & Trace numbers, etc ... and I do this at a specific time of the day (set in Administration Panel)
My server is in UK (DiscountAsp.net) but I'm 2 hours ahead.
What I really wanted is, every time I call DateTime.Now that would be automatically changed to my time instead of Local Server Time. This should handle Daylight savings as well.
I thought about making a Extension to simply call DateTime.MyLocalTime and there use TimeInfo to add / subtract the correct hours.
In good old days I did this in Global.asa (ASP) ... I just wanted to know if there is a better way to handle this.
I am adding a custom header to a SharePoint master page and I would like to display the current time in four different time zones. However, I don't want to use the client's time as there is no way to know what time zone the client will be in, or if they have the correct time on their computer.
Ideally, the time should be displayed as follows:
Dallas: (UTC-6 w/ DST support) Zulu: (UTC) Iraq: (UTC+3) Afghanistan: (UTC+4.5)
My problem is that I really don't know anything about ASP.NET, as I'm a PHP guy myself. So I need a way to pass the serverTime as a variable that JavaScript can use to perform calculations on to display the correct time zone.
UPDATE:
I need the clock to update as each second changes. So it is a live time instead of a static time.
UPDATE 2:
This is the code I'm using.
<script runat="server">
Sub Page_Load(ByVal Sender As Object, ByVal E As EventArgs)
End Sub
Public Function dtBase() As Double
Dim d1 As Date = New Date(1970, 1, 1)
[Code]....
UPDATE 3:
Still don't know if the code worked. My SharePoint server rejected the page for the code blocks. I have absolutely zero idea how to do code-behind. The JS works, but if the client's time is off, the site displays incorrect times. Really wish I could just code this in PHP. I'd be done a week ago. ;)
UPDATE 4:
This update is for anyone that stumbles across this in the future looking for the answer to the problem. The code above has been updated to work correctly. The only catch is that SharePoint disallows code by default, so to enable it, you have to modify the web.config file. The web.config file is usually in the root directory of the site. Inside that file (which is XML), you'll find a tag. Somehwere inside of that, you should find , and inside of that, you should find . Inside of that tag, you want to add this:
<PageParserPath VirtualPath="/relative/path/to/your/file/here.aspx" CompilationMode="Always" AllowServerSideScript="true" />
How show local time in datagridview collumn DateTime from database with universal datetime
View 2 RepliesI'm writing a class to automatically extract information from an excel spreadsheet (using NPOI api) in C#, and then import this information into a database. I've got it all working fine except for one small issue.
One of the spreadsheets I'm working with, contains the date in the following format: 04/01/2011 04:43:28.
When I ran the web application, I got the following error message:
String was not recognised as a valid
So I debugged through the code after this, and it turns out that the date is being read in as:
40546.0151388889, so it is being formattted back to a number.
[code]....
i am displaying some news from rss feeds in the page. But i am stuck up in the date time conversion. I got th published datetime as pdt formated string. How can i convert to my local time. Coversion from the pdt string tot DateTime is error..
[Code]....
This second line is error and i need the result in the specified format or same format as in the published date but in local time ie IST (India Standard Time)
Our business case requires that a Start Time and End Time must be defined for each Organization involved in the business model. For example; some organizations have their working hours from 8:00AM to 5:00PM and others from 9:00 to 6:00PM. While creating a new Event on our calendar these should be queried from the database (StartTime and EndTime) and setting these as default. My questions are:
1) How should I save these times since DateTime requires a Date in front of it and there's no Time column format on SQL Server (Varchar? Number?). If using one of these types how to I concatenate these to a DateTime variable?
2) If the column should be DateTime, how do I concatenate it to replace the column's Date with Today's date and replace the Time with the time specified for that? Let me be more clear:
Default values saved in the database: StartTime = "2010-01-01 8:00AM" EndTime = "2010-01-01 5:00PM" In my code after querying, my local variables would be populated and replaced by: OrgStartHour = "2010-03-26 8:00AM" and OrgEndHour = "2010-03-26 5:00PM"
[Code]....
The code above works but I have no idea on how to replace/concatenate the "2010-01-01" with today's date while keeping the "8:00 AM" on it. :)
I would like to append time also with datetime variable. My Todate need to be in the format of 9/9/2010 23:23:59.
View 5 RepliesI have deployed my asp.net application in my hosting provider they are from US... I have one filed in which i have wriiten Datetime.now.tostring() it saves in Database table it save 11/11/2010 5:20:47 AM
View 17 RepliesI have a column in a Table within an SQL database that is defined as DateTime. I tried to store time data in it, but could only store date information. Am I doing something wrong?
View 6 RepliesBelow is my code when i am inserting it and fetching the saved datetime from database its showing incorrect time, and date is correct.
DateTime d = DateTime.Now;
cmd.Parameters.AddWithValue("@Date", d.ToString("dd-MM-yyyy HH:mm:ss tt"));
There is a "singleline" Textbox in my page in which both date and time are fetch from database table column "DateTime".
I want Time to be come below Date in that "singleline" Textbox.
I can't take that Textbox as "multiline". How to split date and time in singleline Textbox?
How to achieve this?
We have a generic site which we deploy to clients and they personalise the text using the web parts. The problem we are currently experiencing is that they are unable to move web-parts between zones. This is not a JS issue as no errors are being thrown and this is not a CSS issue either, as we re-deployed the website here on our own server and it works perfectly fine. On our client's site, we can drag parts around in the zone it is in, however when we try to move a part out of that zone, we are given a circle cursor with a line through it. Adding parts to a zone is not an issue.
This could perhaps be linked to a previous issue of being unable to view any editable parts of a webpart. I resolved this by removing all the WebPersonalization from the WebPersonalization table in our MSSQL database.
I would like to achieve a nice smooth transition when the user moves controls between the WebPartZones similar to how iGoogle implements it. I've not yet been able to achieve this - the transition is very jumpy and not very smooth (I cannot use SilverLight).
Has anybody achieved this using WepPartZones without the use of SilverLight?
I have a WebPartZone in each of two adjacent columns. There is a gap of about 4 pixels between the two columns that I cannot remove.
I have two zones with the following markup:
[Code]....
On running the page, the relevant source code is:
<%-- End of contents and div containers for Column 1 Zone --%>
...jText at the end of this Webpart.</span>
</td></tr></tbody></table>
</td></tr></table>
</td></tr>
<tr>td style="padding:0;height:100%;"></td>
</tr></table>
</td></tr></table>
</div>
</div>
<%-- Start of div containers for Column 2 Zone --%>
<div id="ctl00_Main_MainCol2" class="box33" style="Width:39.9%;">
<div id="ctl00_Main_MainCol2Con" style="width:auto; margin-left:0.0em; margin-right:0.0em;">
<table cellspacing="0" cellpadding="0" border="0" id="ctl00_Main_ZoneCol2">
<tr><td style="height:100%;">
<%-- The following 2 tables both have cellpadding="2" which appears to be causing the problem --%>
<table cellspacing="0" cellpadding="2" border="0" style="width:100%;height:100%;">
<tr><td>
<table cellspacing="0" cellpadding="2" border="0" id="WebPart_wp1787670866" style="width:100%;">
<tr><td cellpadding="0" style="padding:0px;">
<div id="ctl00_Header_WebPartManager1_wp1787670866"></div>
<%-- Start of contents of Column 2 Zone --%>
<table cellspacing="0" cellpadding="10" style="border: thin solid #000000; background-color: #8db3e2; width:
100%;">
<thead>
</thead>
<tbody>
<tr>
<td><span style="font-size: 12px;">Text at the beginning of this WebPart....
Two of the tables, which I think are rendered by the WebPartZones, have cellpadding="2". This seems to be giving the 4 pixel gap between the columns.
Sometimes I get a datetime with a time sometimes it's just the date. Of course if it's just the date I I want to format with "dd.MM.yyyy" and if it has a time "dd.MM.yyyy HH:mm".. This is in a repeater, so I thought may be it's possible without a simple if statement?
View 3 RepliesI have a MySQL database with a field of type DateTime. When I try to send a date to the DB with the following format:
[Code]....
It does not save the time, only the date and a "00:00:00" at the end. For instance12/1/2011 00:00:00Any idea how I can format save also hours, minutes and seconds? Would it be best to use Timestamps?
I'm trying to convert the javascript date to ASP.NET's DateTime.Now
var todaysDate = new Date();
document.getElementById('hdnDate').value = todaysDate.toString();
private void ConvertToDotNetDateTime()
{
DateTime myDate = (DateTime)hdnDate.Value; ??? ? //bit lost here
}
i have two clock times in my DB as varchar datatype.. i loaded it from db as varchar itself. in C# i have assigned this value to a datetime variable.. how can i get the time from the datetime variable without changing it into a string.
View 4 RepliesI have a datetime column where I store the amount of time a person workded on a project, so it might be 2011-02-16 05:00:00.000 in the column, this being 5 hours. I need to get a sum of the hours in my sproc I tried
[Code]....
But it tells me I cannot sum on datetime.
How do I find the time difference between two datetime objects in ASP.NET?
View 6 RepliesI have a DateTime stored in UTC time that I'd like to display to the user in their local time from within a GridView control. How can I convert my DateTime to the user's time (not my server's local time)? Here is my current field as it appears in the GridView Columns collection:
<asp:BoundField DataField="RunTime" HeaderText="Run Time"
SortExpression="RunTime" DataFormatString="{0:f}" />
in sql 2005 table fields named fromdate and todate which is having the values like as follows
2010-10-23 05:30:20.000
2010-10-24 16:43:10.000
i want to update this date time values like as follows
2010-10-23 00:00:00.000
2010-10-24 11:59:59.000
ie.initial time of the day and the max time of the day
lot of records are thre in fromdate and todate colum .need to update these values with a single query,without chainging the date.Need to change only the time portion
