I have a timestamp that's 13:11:13 and I want it to say 1:11:13 P.M. No biggie - I can convert this myself easily (if >12 subtract 12 and append P.M. otherwise leave alone and append A.M., I guess...) but I thought I'd find a method somewhere. Is there any?
View 2 RepliesI 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?
Anyone know how to format a TIME COLUMN in SQL 08 to regular time and not military time? VB.net
View 2 RepliesI'm saving military time into the database. Then I need to pull this data back out of the database. To get just the time without the date I can do this: String.Format("{0:T}", pullsaved.First.timeValue) But this returns a six digit time, e.g. 100000 (HHmmss). But I want it to return just HHmm (1000). I tried the following, but it didn't work. DateTime.ParseExact(String.Format("{0:T}", pullsaved.First.timeValue), "HHmm", CultureInfo.InvariantCulture)
View 2 RepliesI want to store a military date/time in access DB with VB code. The data type will be date/time in the access db, so i can delete by dates in the past. How would I store this: '6/21/2010 23:23:23'
View 1 RepliesI want to convert date from May 20 2010 2:54PM to 2010/5/17
Has anyone does this before.
I want this functionality both in C# and JavaScript.
In javascript I was trying the following
var dte = new Date();
dte = Date.Parse('May 20 2010 2:54PM')
however this was giving me NaN.
let me know if you want to see my code in C#, it isn't working and I think it is broken so am not posting here.
How could I go about having a client in various time zones select a date and time in their web browser and save it as utc time in my sql database? This date is a date in the future, so whether or not the date is in daylight savings time could change so I'll need to account for that.
The site is a asp.net c# site.
I have an ASP.NET website that worked fine using and debugging in VS2008. I went through the upgrade process opening the solution in VS2010. I can run the site, but as I make changes in the app_code folder classes, they don't seem to commpile and warn me of compile-time errors. As soon as I get to a point that calls the class, the errors show up. Sounds JIT I guess, but this isn't how it was working in 08. Is there an option that was changed in the upgrade process? This is a large project, I really don't want to break something and not find out until some obscure page is opened.
View 1 RepliesHow do you convert a text that says Jan 2010 to 01/2010 in asp.net.
View 3 Replieshow i convert
4/5/2010 4:16:28 into this format 4 May 2010
I am looking to find a regular expression that conforms to military addresses.
View 2 RepliesI have two dates. Date1 and Date2 Date1 contains "10/12/2010 12:00:00AM". Date2 contains "10/10/2010 03:00:00PM" I want to extract only the date from Date1 and extract only the time from Date2 and join them. Example "10/12/2010 03:00:00PM".
View 3 RepliesTimeStamp.Text = BlogComment.Date.UtcNow.ToString("yyyy-MM-ddTHH:mm:ss.fffffffzzz");
BlogComment.Date is a DateTime object with it's date set. TimeStamp is just a literal.
I keep getting unrecognised escape sequence.
Is there an easy way to present time (hh:mm) as a decimal value? Example, 01:08 should become 1,13.I have an asp:textbox masked (ajax) as time with the mask format "99:99". Next to this box I need to present the entered value as decimal.
<asp:TextBox ID="time" runat="server" /> hh:mm ([time in decimal format])
<ajaxToolkit:MaskedEditExtender runat="server" Mask="99:99" TargetControlID="time" MaskType="Time" />
i have two dropdownlists, one for selecting hours, the other for selecting minutes. How can i combine these two values into a time format?
View 3 RepliesIs there a slick way to convert simple numbers (Army time included) to a time format (am, pm format)? I can do the tedious approach, but I was just wondering if there was another way
0800 => 8:00 am
2317 => 11:17 pm
How can I convert the english date 10/29/2010 or any language date to user culture date format
I am using the following code
CultureInfo cultureInfo = System.Threading.Thread.CurrentThread.CurrentCulture;
cultureInfo.DateTimeFormat.
string lng = cultureInfo.TwoLetterISOLanguageName;
DateTime dateTime = DateTime.Parse("10/29/2010", cultureInfo);
but it throws error when I try to parse it.
I have time, for e.g 33 hr 40 mins 50 secs . i would like to convert it to a date time format.
for e.g I have used Convert.ToDateTime("33:40:50"), but in this case when you converting to date time, hour should be less than 24, otherwise it will fire an exception.
I have a literal on my webform. It displays date from a database as 3/26/2011 but I want it to display the date as 26-Mar-2011
How do I do this with VB.NET?
I need to convert time to "UTC+03:30 Time Zone" in my web application here is UTC date : DateTime dt = DateTime.UtcNow; Is there any function to convert UTC to my time zone or not ? I don't want to involve myself writing a new function in my application if there is a function in ASP.NET. The application might be hosted in different server in the world and that's exactly why I have used UTC date. I need a function to add 3:30 to the current UTC time.
View 3 RepliesI'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
}
Is there a function in .net that will take a number such as 134,501 and convert it to time? That time would be 1:45:01 pm. I was hoping i didn't have to reinvent the wheel for this.
View 1 RepliesSuppose I have a string in U.S datetime format, "2/25/2010" and the server is on U.S East Coast with a timezone offset of "-5". When I convert the string via
Convert.ToDateTime("2/25/2010").ToUniversalTime(), it saved as "2/25/2010 5:00:00 AM" (which is correct as local server time for it is 2/25/2010 12:00:00 AM"
Now, suppose my user is in the U.S central time with a timezone offset of "-6", what I want to do is convert it approriately and when this user from central time do "Convert.ToDateTime("2/25/2010").ToUniversalTime()" type of statement, the datetime saved will be "2/25/2010 6:00:00 AM"
Need to convert current System time to GMT time format in c#.
View 3 Repliesif I have 2 date and time like this
02/03/2011 11:11:02 PM and 02/03/2011 12:11:02 PM
can I make like this?
02/03/2011 11:11:02 PM - 02/03/2011 12:11:02 PM
and the result will be
02/03/2011 01:11:02 am
I Think I must convert to ticks and make the minus
but who can I convert ticks to date and time??!!!