date

Date Manipulation in Perl

Hi All, I had a problem with date manipulation.This is my scenario.I have a daily generating report files,they will be generated from Monday to Friday.Now I need to compare those reports.My perl code should work in such a way that if today is Monday I need to compare todays report with previous week Friday's report.And my date format...

jquery date and time picker

hi, i am using jquery date and time picker in one my project where users can create an event. in the jquery datepicker, i have the option to select the today's date and future date and not the past date which is good for an event creattion website. but i am stuck with the time picker. for example, if i am in the event creation page(assu...

String to Date in Java

HI, I am converting String to Date format. But it returns wrong dates. for example, String startDate = "08-05-2010"; // (MM/dd/yyyy) I want to convert this to "Date" object like this, 05-JUL-10 How to do that? I tried like this SimpleDateFormat dateFormat = new SimpleDateFormat("dd-MMM-yy"); scal1.setTime(dateFormat.parse((start...

Using jQuery validate plugin to check if the end date is greater than start date/

Hello every one. I am using jQuery validate plugin and i want to make sure that end date is greater than start date. Is it possible to check this using jQuery validate plugin. Can anyone please help me on this. Your help would be very much appreciated. Thanks. ...

How do I use the current date to pull data to a label?

I'm trying to let the 'date' populate data to a label. Example: a work out schedule suppose today is August 5, so the label might read "do 20 pullups" and then on August 6, the same label might read "do 30 pushups". doesn't matter if the data is coming from an SQLite database or simple array.. I just can't figure out how to get the da...

creating timestamp from columns in postgres

i have 2 rows in a column, one feeding me the julian date (number of days since Jan 1, 1970, with that day being 1), and the second column is the number of minutes past midnight of the current day (why it was done this way, i have no idea). i would like to get my sql query to create a timestamp out of these two columns. if i had access...

Pivot tables without aggregation?

I have a list of items - each item has a title, plus a bunch of attributes, including a date. If I drop the date into the row box of a pivot table, then group it, and drop the title below - so I have Years, Quarters, Created On, Title, I get a nice list of all the titles in my data, grouped by year, quarter and month. But I want to als...

PHP date formatting issue

This PHP statement date('Y-m-d',1281394800) returns different values in different servers. One gives me 2010-08-09 and the other 2010-08-10. Could someone please help explain? ...

perl help finding proper date format

I need some help trying to figure out how to format dates in perl. I have a working perl script, with a regular expression, that works fine if I use hard coded date strings like this: my $mon = 'Aug'; my $day = '05'; my $year = '2010'; These vars are used in a regular expression like this: if ($line =~ m/(.* $mon $day) \d{2}:\d{2}:\d...

What I have minus months in database (mysql), is it the php code?

Hi, Description: I am doing purchasing function, whenever the users make purchases, it will add 1 month privilege to my access special page of my site. I have received some complaints from my users, please read the problem section. Problem: Out of 500 users, there are few users, that for example: make purchase today, but the expirati...

Looking for a SQL function to pull data for month selected and previous six months.

I am looking for a SQL function to use in a BOE Report to generate data from the month selected in the prompt and the previous six months. ...

sort date objects in Python

I start out with date strings: from operator import itemgetter import datetime as DT # unsorted dates raw = (map(int, "2010-08-01".split("-")), map(int, "2010-03-25".split("-")), map(int, "2010-07-01".split("-"))) transactions = [] for year, month, day in raw: new = (DT.date(year, month, day), "Some data here") t...

Group together arbitrary date objects that are within a time range of each other

I want to split the calendar into two-week intervals starting at 2008-May-5, or any arbitrary starting point. So I start with several date objects: import datetime as DT raw = ("2010-08-01", "2010-06-25", "2010-07-01", "2010-07-08") transactions = [(DT.datetime.strptime(datestring, "%Y-%m-%d").date(), ...

Changing link class based on dates

I have got a list of menus up on our website with the current week's menu highlighted with a different colour background which is decided by a class of 'current' on that item. At the moment I change this class manually each week but was wondering if there is something I can set that changes the class automatically based on dates that I g...

Problem with date, membership expired but it isn't yeat

Hi there, I need to modify my valid notification script (which notify members, before membership expiration, on expiration day and so on), to work on specific way. So my expires column in database (MySQL) is datetime type so value in it for example look like this: 2010-08-08 13:46:38 Here is a thing: Script can be called from backend...

Get a MYSQL Date into a c# String exception

Hi. I'm trying to extract a date field from a mysql db using .NET and MySQL .NET Connector. Whithin the test everything works great except the date, I mean, I can get the varchar fields but the DATE field (called R_DATE) is impossible. My SQL Query is: SELECT * FROM TABLE And, the way I'm trying to read it is: DateTime date = reade...

Comparing mysql dates in php

Hi Guys. I'm creating an application for a friend to handle Deadlines. I have a page set up where each user can see their own 'jobs to do' with a deadline next to it. My question is... How do I compare a deadline date that comes back from the mysql query as 2010.08.08 with today's date? For Example... <?php while($row = mysql_fet...

Extract inconsistently formatted date from string (date parsing, NLP)

I have a large list of files, some of which have dates embedded in the filename. The format of the dates is inconsistent and often incomplete, e.g. "Aug06", "Aug2006", "August 2006", "08-06", "01-08-06", "2006", "011004" etc. In addition to that, some filenames have unrelated numbers that look somewhat like dates, e.g. "20202010". In ...

How to add long value to calendar?

Calendar's add method in Java takes an integer as an input int secs = 3; cal.add(Calendar.SECOND, secs); But what if the seconds are Long type. long secs = 3 There's quite a few possibilities like adding the seconds iterative, but what are the other options? ...

Retrieve dates from Oracle DB

I'm using an Oracle DB and I'm trying to fetch data from its tables using PHP. One of the tables contains a date column which behaves strange to me. When I open the table in my DB client (I'm using Navicat Lite) I see dates like "2007-11-29 10:15:42" but when I retrieve them with PHP and display the date it says "29-NOV-07". I use a sim...