date

Java Date getDate() depricated, refactored to use calendar but looks ugly

Eclipse is warning that I'm using a depricated method: eventDay = event.getEvent_s_date().getDate(); So I rewrote it as eventDay = DateUtil.toCalendar(event.getEvent_s_date()).get(Calendar.DATE); It seems to work but it looks ugly. My question is did I refactor this the best way? If not how would you refactor? I need the day num...

Has date type changed in SQL Server 2008?

I am confused reading statements in "Why is 1899-12-30 the zero date in Access / SQL Server instead of 12/31?" Was there date type in SQL Server before 2008 version? I cannot find. In SQL Server 2008 zero date is 0001-01-01. Were there any date type before (in previous SQL Server versions) how is it backward compatible? ...

Current est time in java with daylight saving

Hi, All I stumbled upon this piece of code to get current time in EST with daylight saving. It seems to work fine, when checked on the internet by the time displayed in sites providing current time in EST with daylight saving. SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MMM-dd HH:mm:ss.SSS"); dateFormat.setTimeZone(Ti...

Calendar generation strange fail

I set out to generate a array containing a 12-month calendar starting on this (now) month. This is for a particular application, and requires special code, so I cannot use calendar libraries. Here's the code I have: header('Content-type: text/plain'); $Cal1 = array(); $now = new fTimestamp('now'); $now = $now->modify('Y-m-1 00:00:00'...

Access - VBA Code problem Date- problem

Hey all, have managed to finish the database; but have run into a problem with something I did in the beginning. Basically, the calculations in the database are done using VBA code. Now I've run into a problem where instead of slecting just the last two years worth of data, it is now slecting and using data from more than two years ago. ...

Set a review date on a sharepoint 2010 document

In sharepoint 2010 I need to be able to set a review date on a document and be emailed when this review date is reached. Is this possible? Thanks for any pointers ...

NHibernate Delete with date arithmatic using HQL

Hello, I've looked around and can't find too much. But is it possible to do something like this using HQL in nHibernate: Session.CreateQuery(@"DELETE FROM MyObject mo WHERE (mo.AlteredDate + mo.ExpiryDetails.ExpiryTimestamp) < :pNow") .SetDateTime("pNow", DateTime.Now); So basically I want to...

Date formatter is not formating the date correctly.

I wrote this following java code to format the date and time in specific formats.You can see the below code at ideone . import java.util.Calendar; import java.util.GregorianCalendar; import java.text.SimpleDateFormat; class timeAndDateTransformation{ public static void main(String[] argv){ Calendar newDate = new Gregoria...

Filtering based on comparisons in django

I have a django model with a field Reminder_End_Date = models.DateField(). I have to filter all records of the model which have reminder date greater than todays date. However when I try to use the following statement, it does not work: now=datetime.date.today() reminderlist=Reminder.objects.filter(Reminder_End_Date>now ) Can anyone ...

In IPhone(Objective C) how do I get the current date formatted in miliseconds to send to a server Rest Web Service?

Hi, I am new to IPhone development. I need to take the current date from device and send to a server in JSon format. The server expects this date to be in milliseconds as since January 1, 1970, 00:00:00 GMT(Unix time) . I have noticed IPhone has some methods to get the current time in SECONDS, well, should be very easy to transform se...

How can I return or load a specific date?

Is there a way to return or load the calendar by an get URL. Something like calendar.php?gotoDate=2010-10-21 ? Many Thanks! Edits go here (not in answers or comments): Oops! I'm sorry: http://arshaw.com/fullcalendar/ ...

SQL query to combine several tables to find price of item every day

I am trying to build a table to show me the price of an item each day over a specified time period. I begin with three tables: one containing the sale price with a start and end date, one containing the regular price of an item and when it started at that price, and one date table that just has dates for filling in blanks. Tables: S...

SQL date ranges

Possible Duplicate: 90 days range using SQL server I am trying to get the counts 90 days prior to the operational date and the counts 90 days after the operational date. For example, my operational date is 4/1/2004. So,90 days prior to 4/1/2004 is (1/2/2004 to 3/31/2004) and 90 days after (including 4/1/2004) is 6/29/2004. I ...

DateUtils.parseDate doesn't throw ParseException on invalid dates

java.util.date = org.apache.commons.lang.time.DateUtils.parseDate(value, new String[] { "mm/dd/yyyy" }); If you give an invalid date string (e.g. value = 13/02/2000 or value = "12/35/2000"), this didn't result in an error (e.g. 13 as a month is invalid and 35 as a date is invalid). But the above function just moved the appropriate date ...

Repeating escaped chars in a PHP date function, within Drupal6/Views

I am trying to make a custom php date function for use within D6 that will show dates in the correct format for Chinese. I created the date format within the Date API area of D6, something along the lines of: Y\年n\月j\日 In the Date admin area, this correctly display as "2010年10月22日". My problem occurs when I bring this over to Views w...

What's the function of the Publish field of items in Sitecore

Hi, I am wondering what the function is of the Publish field of items in Sitecore. Just to be sure I am clear about what field I am talking about it's the field in the "Publishing" section of an item which is only shown when you check the "Standard fields" option. Normally that field is not filled in and I expected it to be filled auto...

Date & Time Stamp Form results via email? How?

I wrote this PHP script to retrieve my form results via email. Everything works great, but I don't know how to add a time and date stamp of the results. Here is my current code: <?php $name = $_REQUEST['name'] ; $carenumber= $_REQUEST['carenumber'] ; $email = $_REQUEST['email'] ; $topic = $_REQUEST['topic'] ; $message = $_REQUEST['mes...

timestamp and subtract objective C

I need to find the specific time a tap happens and then the time since it has passed. I have the app counting taps, I just haven't figured out the time thing. I tried: timeStamp = [[NSDate date] timeIntervalSince1970]; but I'm new to obj c and clearly there is a syntax problem. Thanks for anyhelp. ...

javascript date and year

I have the following javascript code: <script type="text/javascript"> $(function () { var currentDateTime = new Date(); var oneYear = new Date(); oneYear.setYear(oneYear.getYear() + 1); alert(currentDateTime + "_" + oneYear); }); </script> i would expect the alert to output the current datetime ...

MYSQL user statistics query help?

I have a table (statistics) with the columns User, Date (datetime), Page and IP. I have this query: SELECT * FROM statistics WHERE page LIKE '%page_name' ORDER BY date DESC LIMIT 30. That's ok to display all the user that visited that page. But I would like to display unique ips per day, something like DISTINCT ip (per day) I don't k...