date

Java Joda Time - Implement a Date range iterator

Hi all, I'm trying to implement without success a Date iterator with Joda time. I need something that allows me to iterate all the days form startDate to endDate Do you have any idea on how to do that? ...

Date formatting from SQLite query

I'm trying to pull and format timestamp from my SQLite db. In my reading, it seems that SQLite formatting is extremely limited compared to date formatting conversion available to PHP. I have this query coming from javascript: SELECT strftime('%m %d, %Y', timestamp) AS saveddate And it returns: 03 03, 2009 I'm trying to get it to re...

How can I sort a dd/mm/yyyy formatted date by month using Perl?

I have a list of dd/mm/yyyy dates stored in a hash that I need to sequentially print out in order of date by month. Here is the relevant excerpt. use feature 'say'; for my $date (sort {$a cmp $b} keys %data) { say $date; } This outputs: 16/07/2008 16/08/2008 16/09/2008 17/07/2008 17/08/2008 17/09/2008, etc. when what I need is...

Finding date by subtracting X number of days from a particular date in Javascript

Hi All, I want to find date by subtracting X number of days from a particular date in JavaScript. My JavaScript function accepts 2 parameters. One is the date value and the other is the number of days that needs to be subtracted. For example, I pass my argument date as 27 July 2009 and i pass my other argument as 3. So i want to ca...

How to show yesterdays date in this format?

I know there is a lot of info on the neton how to show yesterdays date but I am unable to get any of them to work in this format How do you show yesterdays date if todays date is in this format date('F jS, Y') ? July 27th, 2009 should show July 26th, 2009 //Does not work $yesterday = date('F jS, Y', mktime(0, 0, 0, date("F") , date("...

in c++ how can I find the maximum system date?

I'm trying to find the maximum allowed system date in cpp, but I can't find the function to do that... Can anyone help me? ...

Java: date & time relative to current (server) time

We're using MySQL to store some dates. I'm looking to show these as relative time periods in the user interface: 2 hours ago, 3 days ago etc. (Like Twitter does for the updates for example) Is there a well-known way to accomplish this, or should I get creative with it? Just to be clear, I want to transform: 07/26/2009 12:20 -> '2 days ...

How to add 30 minutes to a javascript Date object?

I'd like to get a Date object which is 30 minutes later to another Date object. How to achieve it? Basically: Tue Jul 28 16:00:00 UTC+0800 2009 add 30 min to Tue Jul 28 16:30:00 UTC+0800 2009 Tue Jul 28 16:40:00 UTC+0800 2009 add 30 min to Tue Jul 28 17:10:00 UTC+0800 2009 ...

How do I easily determine the age from an birthday? (php)

Possible Duplicate: Calculate years from date Hi, I have a table with a field representing the birthday. How do I find the age of the person from that date? This is what I have. $qPersoonsgegevens = "SELECT * FROM alg_persoonsgegevens WHERE alg_persoonsgegevens_leerling_ID = $leerling_id"; $rPersoonsgegevens = mysql_query(...

sas date - convert today() into yyyymmdd format..

How do I convert a SAS date such as "30JUL2009"d into YYYYMMDD format (eg 20090730) ?? so for instance: data _null_; format test ?????; test=today(); put test=; run; would give me "test=20090730" in the log.... ...

Parse Italian Date with Ruby

I would like to use Date.parse, but it doesn't work with Italian month names! Date.parse "26 agosto 1991" => Sun, 26 Jul 2009 Is there any alternative? ...

JSP client's date and time

Is there any specific way of getting client's date and time without using any Javascript at all,but only using a JSP, As I know there are ways to get clients IP using some of the methods below. getRemoteAddr, getRemoteHost and getRemotePort So I'm asking other way around,Is there any way please post it here. Thanks. ...

How to make software expire on a certain date on Windows ?

Hello, I have a piece of Windows/C++ application which includes a hard coded expiry date, so that the release expires and stops running on a certain date like, 30 of august 2009. Obviously the user can take back the system time to work around this limitation. Is there a good way to stop my application running if the date has passed ev...

Javascript date parsing bug - fails for dates in June (??)

I have some javascript which parses an ISO-8601 date. For some reason, it is failing for dates in June. But dates in July and May work fine, which doesn't make sense to me. I'm hoping a fresh set of eyes will help, because I can't see what I'm doing wrong here. Function definition (with bug) function parseISO8601(timestamp) { var ...

Specifying date input format

I have a asp.net textbox for date input, I use regular expression to let the user input date in dd-mm-yyyy format but when i convert the input date in datetime object, the month and day values are interchanged. How can a specify the right way for interpreting this input date? ...

How to add day to date in Linq to SQL

I am writing this code. Here dt is input into the function, as well as someint. The column Exp is a T-SQL date column, which comes as a DateTime through Linq. return (from a in dataContext.TableOfA where a.name == "Test" && a.Exp.Value.AddDays(Convert.ToDouble(Someint)) >= new DateTimeOffset(dt) select a).First(); ...

what is the best method to translate strings to mysql dates?

What is the best way in php to take the following string mm[some char]dd[some char]yyyy and translate it to yyyymmdd? I will probably want in the future, according to local do the same with dd[some char]mm[some char]yyyy. If there is a way that already uses the Zend Framework API, the better ...

Easy way to get day number of current quarter?

PHP provides ways to get the number of the current day of the month (date('j')) as well as the number of the current day of the year (date('z')). Is there a way to get the number of the current day of the current quarter? So right now, August 5, it is day 36 of the third quarter. If there is no standard way of calculating this, does an...

Outputting Time - a DateTime entry

Related: This is a continuation from my earlier question, Wrong Logic in If Statement? $repeat_times = mysql_real_escape_string($repeat_times); $result = mysql_query("SELECT `code`,`datetime` FROM `fc` ORDER by datetime desc LIMIT 25") or die(mysql_error()); $output .=""; $seconds = time() - strtotime($fetch_array["datetime"]); ...

Wrong logic in If Statement?

$repeat_times = mysql_real_escape_string($repeat_times); $result = mysql_query("SELECT `code`,`datetime` FROM `fc` ORDER by datetime desc LIMIT 25") or die(mysql_error()); $output .=""; $seconds = time() - strtotime($fetch_array["datetime"]); if($seconds < 60) $interval = "$seconds seconds"; else if($seconds < 3600) $interval ...