datetime

explanation for behavior from SimpleDateFormat

Try this: DateFormat df = new SimpleDateFormat("y"); System.out.println(df.format(new Date())); Without reading the javadoc for SimpleDateFormat, what would you expect this to output? My expectation was "0". That is to say, the last digit of the current year, which is 2010. Instead it pads it out to 2 digits, just as if the format ...

How to handle splitted date fields (year, month, day) in ASP.NET MVC

In need splitted date fields for dob (like the facebook registration form) in my current project. I currently have a working solution but this solutions seems a little bit "dirty". My solution is a DTO for the splitted date and an editor template for this type. public class SplittedDate { public int Day { get; set; } ...

Need a the last records of a day, from a range of days.

Ok heres the problem, I have 5 different tables created by god knows who each with different data, an dI need to merge them in a single table. My first problem is that each day have a time stamp but I only need the last records add each day, so how can I search each day for the last records and save them on a new table, most of this tab...

Sorting a time value in a dataset

In my current solution, I am converting a DateTime value, "Time" in my database using CONVERT so it displays in a ##:##AM/PM format, and I realize that CONVERT just takes whatever datatype and turns it into a VarChar, or a String once its in C#. This is making my sort work incorrectly in my Gridview. I am sorting the columns in my DataSe...

DateTime parsing issue.

I am trying to parse this datetime, but it always return false. DateTime.TryParseExact("07/01/2007 12:15", "mm/dd/yyyy HH:mm", new CultureInfo("en-US"), DateTimeStyles.None, out met) ...

.NET DateTimePicker

I’m currently trying to use this control to provide a means of selecting a date and time from a dialog box. However, I can’t seem to work out how to allow selection of a date AND time (format seems to allow short, long, custom and time). Please could someone point me to the relevant property for this? ...

convert any date string to timestamp without timezone

I'm getting xml and rss feeds and putting the data into a database. I've run into two different date formats so far... Wed, 21 Jul 2010 00:28:50 GMT And 2010-07-20T17:33:19Z I'm sure there will be more. My postgresql database for the date is timestamp without time zone. Is there an existing function in php or is there a procedure t...

Add 1 Week to a Date, which way is preferred?

I am reviewing some code at work and came across an inconsistency in how the code handles adding 1 week to the current time and was wondering if there was any reason why one should really be preferred over the other: The first was a utility method: public static Date addDaysToDate(final Date date, int noOfDays) { Date newDate = new...

xslt: time ago test

using xslt how do i test if a date was within the last (say) 15 days? input: date in format dd/mm/yy X number of days output: if the date occured within X days of now eg recent('02/07/10',30) would return true iff 02/07/10 was 30 days in the past some steps i got: main func <xsl:function name="custom:monthtodays"> <x...

iPhone 4.0 NSDateFormatter crashes..

Hi all! I need to convert a NSDate to a string using my personal data format... The problem is that this code on the simulator (4.01) crashes... sometimes the code is "freezed", sometimes give the BAD_ACCESS... here is the code: NSDateFormatter *dateFormat = [[NSDateFormatter alloc] init]; ...

Python Strptime() and timezones?

Hi, I have a CSV dumpfile from a Blackberry IPD backup, created using IPDDump. The date/time strings in here look something like this (where EST is an Australian time-zone): Tue Jun 22 07:46:22 EST 2010 I need to be able to parse this date in Python. At first, I tried to use the strptime() function from datettime. >>> datetime.dateti...

Add DATE and TIME fields to get DATETIME field in MySQL

Hi, I am trying to get a DATETIME field from a DATE and a TIME field. none of the functions in MYSQL seems useful. Is somebody aware how to do this or that if this can even be done? :) ...

Get DateTime Value from TextBox in FormView

I need to find a value in a TextBox, contained within a FormView which holds a short date. DateTime LastPayDate = (DateTime)FormView1.FindControl("user_last_payment_date"); I get the error: CS0030: Cannot convert type 'System.Web.UI.Control' to 'System.DateTime' And, I have no idea how to put a value back in the same format. Would ...

.Net DateTime.Subtract Issue

I have a function that returns the difference between 2 DateTime's in seconds. However, in certain cases its not working correctly and I'm not sure why. I.E.: Debug.WriteLine(DateTime.Parse("7/22/2010 9:52:39 AM").Subtract(DateTime.Parse("7/22/2010 8:58:38 AM")).Seconds, "WTF"); The above code returns 1 ... obviously there's more tha...

Easiest way to parse a Javascript date in C#?

I see that JSON.NET has a DateTime converter: string javascriptJson = JsonConvert.DeserializeObject(entry, new JavaScriptDateTimeConverter()); However I don't have a JSON object, I simply have a string: /Date(1276146000000-0500)/ I could create an object, add the date, then parse it, but this seems common enough that there should b...

Javascript Date.parse help

I am using Javascript Date.parse() to check if a start time is after an end time. The time in question is like this: Date.parse("12:00pm") > Date.parse("9:30pm") In Chrome this is coming up as false (as it should) In IE it is incorrectly coming up as true. The values Chrome see's are: Thu Jul 22 2010 12:00:00 GMT-0400 (Eastern Day...

SQL: Insert DateCreated value?

In my table I have a dateCreated column in the format of DATETIME. How do I insert the current datetime when I add the record to the database? ...

How do you subtract from a datetime?

I'd like to write a simple function to say in hours : How much time has passed since this has been created? My attempts are futile. -time = DateTime.now.hour - (self.created_at.hour) Does anyone know how to do this in Ruby on Rails? ...

Serialize Datetime without GMT in C#

Hello, I have generated classes from xsd and want to serialize the DateTime. My class looks like private System.DateTime timeGMT; [System.Xml.Serialization.XmlElementAttribute(DataType="time")] public System.DateTime TimeGMT { get { return this.timeGMT; } set { this.timeGMT= value; } }...

how do I get a string format of the current date time, in python?

A string is returned July 5, 2010 ...