date

Why is the Date format changing?

I have an Excel spreadsheet where there is a date column, and the date is entered in the format of dd/mm/yyyy. When I open this file in My Excel, the Date column converts to date, but in the format of mm/dd/yyyy automatically. i.e., 12/03/2009 4:44:44 (12March) but it takes it as 3rd Dec 09.. Would you please shed some light on the ma...

MySQL Slow on join. Any way to speed up

I have 2 tables. 1 is music and 2 is listenTrack. listenTrack tracks the unique plays of each song. I am trying to get results for popular songs of the month. I'm getting my results but they are just taking too long. Below is my tables and query 430,000 rows CREATE TABLE `listentrack` ( `id` int(11) NOT NULL AUTO_INCREMENT, `se...

Does anyone know of a good pre-existing javascript date range drop-down?

I'm looking for a javascript drop-down for a date range that allows the user to select start and end dates from a single form field, similar to what exists in the Google Analytics UI. I've found a lot of pre-existing javascript for two separate form fields, or for using a calendar to choose a single date, but nothing that accomplishes...

javascript date subtraction

Hello I am looking for a way to do proper subtraction between two javascript Date objects and get the day delta. This is my approach but it fails for todays date as an input: <script type="text/javascript"> function getDayDelta(incomingYear,incomingMonth,incomingDay){ var incomingDate = new Date(incomingYear,incomingMonth,incomingDay);...

Mysql bad date (data) in string field how to find/validate?

I have a string field in Mysql (date fields imported from from MSSQL) and I'm using the following to convert the string value and place it in a new (MYSQL) date-time field, Update Table_name set STATUS_DATE= STR_TO_DATE(substring_index(SSTATUS_DATE," ",1),'%c/%e/%Y'), somewhere in the table I have bad data and the query stops and ...

formatting dates in Grails

I have a domain class in Grails with a field journeyDate. journeyDate is defined like this:- Date journeyDate then in my list.gsp I display the date like this:- ${fieldValue(bean:journeyInstance, field:'journeyDate')} And it is displayed in the following format:- 2009-08-19 17:12:00.0 does anyone know how I can format this on the l...

CMD/BAT - Help determining date 36 days ago.

Each night I need to do work on a folder 36 days old from the current date. I have a system that writes files to a daily structure like below. I need to keep 35days worth on the local disk and so each night I need to archive off the 36th day. Here is the kicker... There are approx 2 million files per day, so I cannot efficiently scan ...

php make date with format mm-dd-yyyy

I have a date in the following format MM-DD-YYYY How can I convert this to UNIX time in PHP Thanks Having a small problem $date = strtotime($_POST['retDate']); print $date; //Prints nothing print $_POST['retDate']; //Prints 08-18-2009 ...

JavaScript won't parse GMT Date/Time Format

Hi, I'm trying to get JavaScript to parse a date and time format for me, with the eventual aim of telling me the days passed since that date and the time right now (locally). Unfortunately, the date format I have to work with (it's from a JSON response which I don't have control over) is returning it in 2008-10-01 06:21:43 type format...

Inconsistent date parsing using SimpleDateFormat

I'm really scratching my head on this one. I've been using SimpleDateFormats with no troubles for a while, but now, using a SimpleDateFormat to parse dates is (only sometimes) just plain wrong. Specifically: SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss"); Date date = sdf.parse("2009-08-19 12:00:00"); System.out.prin...

Need assistance padding numerical month and day with leading 0

I am working within a batch file and need to pad a single digit with a leading 0 if under 10. I have the values in environmental variables. They are month and day, I need to pad to match file structure I am working against. I am using vbscript to return a date that comes back in the following format "7/16/2009". Need it to look like ...

MySQL Get rows between months

Hi all, I'm trying to SELECT the visitors of my site per month for the current year. For every different IP/user_agent combination there will be added a row per minute. To track the hits and the unique visitors. My scheme looks like this: CREATE TABLE `stats` ( `id` int(11) unsigned NOT NULL auto_increment, `domain` varchar(4...

MySQL - return only entries from the past X days

I'm working with a database that has date information stored as a Unix timestamp ( int(11) ) and what I want to do is only return entries from the past X days, the past 90 days for example. What I've come up with is: SELECT * FROM mytable WHERE category=1 AND FROM_UNIXTIME( time ) > DATE_SUB(now(), INTERVAL 91 DAY) Where 'time' is t...

MySQL Date Search MM/DD/YYYY to MM/DD/YYYY

I have a table in MySQL That looks like the following: date |storenum |views ------------------------------- 08/21/2009 |42 |3 ------------------------------- 08/22/2009 |43 |1 ------------------------------- 08/21/2009 |43 |4 ------------------------------- 08/22/2009 |42 |22 ------...

iPhone SQLite date problem

Database gets created just fine, and the insert works just fine. I'm having problem with the select statement below. It returns no records and no error. A select on any other field works just fine. Can anyone spot what I'm doing wrong? "create table if not exists data (pkey integer primary key, doc date)" [db executeUpdate:@"insert int...

What's wrong with the MySQL DATE() function?

I've had some bizarre results from queries I've been testing out with the DATE function, culminating in these little beauties: mysql> SELECT id FROM job WHERE DATE(due)=CURRENT_DATE; Empty set (0.00 sec) mysql> SELECT id FROM job WHERE DATE(due)=CURRENT_DATE AND id>2022; Empty set (0.00 sec) mysql> SELECT id FROM job WHERE DATE(due)=C...

Date and Time helper for PHP (like jodatime in java)

Hi, I am looking for library (open source) like Joda Time in Java world. is there any library like that ? Joda Time is very helpful to calculate date and time. I can add days, weeks, month, year and also can converting date and time easily. I wish there is library like joda time for PHP edit: I need some functions that available in...

MySQL Inserting invalid dates

again, this qn was from the practice qns in the mysql certification guide book ... QUESTION Here's the structure of a table typetest with three columns (number, string, and dates). As- sume the server is running in MySQL's “forgiving” SQL mode. mysql> DESCRIBE typetest; +--------+---------------------+------+-----+---------+-------+ ...

PHP date() in foreign languages - e.g. Mar 25 Aoû 09

I have a script that needs to display date data to an international audience - e.g. "submitted Tue 25 Aug 09" Is there an easier/cleaner way to get this converted to the French(etc) equivalent "Mar 25 Aoû 09" than: Setting a constant LANG and a $LANGUAGES array of include files & : if(LANG != 'EN') { include $LANGUAGES['LANG']; }...

Infopath form-creating a date range to query

Is there a way to create a date range and query by that date range for an infopath form created with a database setup, actually a sql server. I have been trying to create a date range filter that can be used with the "drag query fields option" while developing a form. ...