Search Results

Search found 13055 results on 523 pages for 'date calculation'.

Page 304/523 | < Previous Page | 300 301 302 303 304 305 306 307 308 309 310 311  | Next Page >

• joining two tables and getting aggregate data

  - by alex

  how do i write a query that returns aggregate sales data for California in the past x months. ----------------------- ----------------------- | order | | customer | |-----------------------| |-----------------------| | orderId int | | customerId int | | customerId int | | state varchar | | deposit decimal | ----------------------- | orderDate date | ----------------------- ----------------------- | orderItem | |-----------------------| | orderId int | | itemId int | | qty int | | lineTotal decimal | | itemPrice decimal | -----------------------

  Read the article

• Set language code inside a view in django

  - by origon

  Im wonder how to set the language code inside a view (in django). Im sending a HttpResponse that contains a python-date.strftime("%A") %A = The day (ex: Monday). But I want to get the day in swedish instead of english.

  Read the article

• Convert octet string to human readable

  - by Michael Lang

  Using the pysnmp framework i get some values doing a snmp walk. Unfortunately for the oid 1.3.6.1.21.69.1.5.8.1.2 (DOCS-CABLE-DEVICE-MIB) i get a weird result which i cant correctly print here since it contains ascii chars like BEL ACK When doing a repr i get: OctetString('\x07\xd8\t\x17\x03\x184\x00') But the output should look like: 2008-9-23,3:24:52.0 the format is called "DateAndTime". How can i translate the OctetString output to a "human readable" date/time ?

  Read the article

• Is there such a thing as Cakephp "user management" plugin script

  - by Toomas Neli

  is there anywhere such script that includes a cakephp user management part, view - registration form ( for example allowing to enter: first name, surname, email, user address, user phone number, last login date etc. ) sends confirmation to email - about registration inserts users data into mysql tables (users id, etc.) and blocks duplicate entries to users tables or does other similar tasks etc. if there is no such plugin then may be someone can send the custom made scripts

  Read the article

• How to find out when each user's last commit was to subversion?

  - by llaskin

  I have a repository that is running subversion. Some users have not been committing regularly. I'd like to send out a weekly reminder to those that have not committed during the last week. Is there a way to determine when each users last submit date was?

  Read the article

• Get consolidated results with following tables

  - by Ted

  I have a scenario. Here's my table structure is: ID LoginDate RemovalDate ---------------------------------------- 1 2009/08/01 NULL 2 2009/09/12 2010/01/02 3 2009/08/31 2009/10/29 4 2010/02/17 NULL 5 2009/10/18 2009/11/22 I want a consolidated results of how many ID's were not removed in a particular month. So the result set should be Date NotRemoved_ID -------------------------- 2009/08 2 2009/09 3 2009/10 3 [One ID got removed in 2009/10] 2010/02 2 [Two got removed in 2009/11 and 2010/01] Please help.

  Read the article

• comparing dates in c# taking null value into account

  - by Saif

  Hi I am new to c#. I am comparing two dates where one is entered by user and the other one is sytem date time. i have the code working as it stands where the obstacle has occured is how to cater for null values. the basic code I have is: if (mydate.ToShortDateString() != TodaysDate.ToShortDateString()) { //Error Messaage } else { //do some code } Any feedback will be appreciated

  Read the article

• how to create array of a week days name in php

  - by I Like PHP

  i want to create an array of 7 days through php means all 7 days name... i don't want to write ..sunday monday tuesday...etc... and days will be started from sunday .. means if today is 29 march( monday) then it automatically grabs the current date and create an array of days name starting from sunday. array always be in this way $weakarray=("sunday","monday",......,"saturday");

  Read the article

• IIS headers of aspx page appear on page sometimes, any idea why?

  - by Chris

  At random this output it occurring at the top of the page. Site is installed on a lot of servers issue only happens on one server. HTTP/1.1 200 OK Date: Mon, 24 May 2010 04:18:30 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET X-AspNet-Version: 2.0.50727 Cache-Control: private Content-Type: text/html; charset=utf-8 Content-Length: 39611

  Read the article

• Sort files by last edited after finding them in a specific directory?

  - by meder

  I'm looking to combine find . -mtime 0 and ls -lt To find all files modified in the last day in the current working directory, sorted by last modification date.

  Read the article

• timestamp in C#

  - by praveen

  Hi all, I need to convert the system datetime to timestamp in script task SSIS. input date format: 29/05/2010 2:36 AM output format: 29-15-2010 14:36:00 thanks prav

  Read the article

• Portable C++ IDE

  - by Click Ok

  I want a portable C++ IDE for general development, and too to develop basic Windows GUI applications. In my research, I've found this (with latest version date): CodeLite IDE (2010-04-02) Code::Blocks (2008-02-28) Bloodshed Dev-C++ (2005-02-22) NetBeans (2009-12-10) Ultimate++ (2010-03-16) Qt Creator (2010-02-01) But I don't know if some these IDE's supports Windows GUI development (or Cross Platform GUI development) or if can be Portable (NetBeans can be portable).

  Read the article

• Greatest not null column

  - by Álvaro G. Vicario

  I need to update a row with a formula based on the largest value of two DATETIME columns. I would normally do this: GREATEST(date_one, date_two) However, both columns are allowed to be NULL. I need the greatest date even when the other is NULL (of course, I expect NULL when both are NULL) and GREATEST() returns NULL when one of the columns is NULL. This seems to work: GREATEST(COALESCE(date_one, date_two), COALESCE(date_two, date_one)) But I wonder... am I missing a more straightforward method?

  Read the article

• How to perform an action when a remote (Http) file changed?

  - by ZeissS

  Hi, I want to create a script that checks an URL and perform an action (download + unzip) when the "Last-Modified" header of the remote file changed. I thought about fetching the header with curl but then I have to store it somewhere for each file and perform a date comparison. Does anyone have a different idea using (mostly) standard unix tools? thanks

  Read the article

• Routing error in rails

  - by user662503

  In my controller I have def update_project_dates p "It is end date....." @user=User.find(params[:user]) @projects=Project.find_all_by_user_id(@user) end In the view page (only some part of the code is copied and pasted) eventDrop: function() { $.ajax({ url:'/update_project_dates/', success:function(data) { alert("Hello"); } }) }, In my routes.rb I have mentioned match '/update_project_dates' => 'users#update_project_dates', :method=> :get get 'update_project_dates' But When the ajax request goes, I get the routing error as Routing Error uninitialized constant UsersController Where am I doing wrong here...Please help..

  Read the article

• MySQL: Query Cacheing (How do I use memcache?)

  - by Rachel

  I have an query like: SELECT id as OfferId FROM offers WHERE concat(partycode, connectioncode) = ? AND CURDATE() BETWEEN offer_start_date AND offer_end_date AND id IN ("121211, 123341,151512,5145626 "); Now I want to cache the results of this query using memcache and so my question is How can I cache an query using memcache. I am currently using CURDATE() which cannot be used if we want to implement caching and so how can I get current date functionality without using CURDATE() function ?

  Read the article

• How do I specifiy or override the file and path name for ftp publish location after a hudson build?

  - by Tim

  I am using hudson and the "Publish artifacts to FTP" option. It makes up its own directory based on the date and time of the build. I would like to override that with a fixed name/location. How can I do that? Is it possible?

  Read the article

• query mysql table and fetch rows posted in 3 days

  - by Mac Taylor

  Hey guys how can i query my mysql database and fetch rows which are posted in earlier 3 days i know how to fetch todays's rows but not 3 days ago time will save in my table like this : 2010-01-20 19:17:49 and this is what i know : SELECT id FROM pages WHERE date=now() but i need to show posts in 3days and im looking for a simple and straight solution ,because i know how to do so in long php codes

  Read the article

• preg_replace replacing with array

  - by Scott

  What I want to do is replace the "[replace]" in input string with the corresponding vaule in the replace array. The total number of values will change but there will always be the same number in the replace array as in input string. I have tried doing this with preg_replace and preg_replace_callback but I can't get the pattern right for [replace], I also tried using vsprintf but the % in <table width="100%"> was messing it up. All help is greatly appreciated! Replace Array: $array = array('value 1','value 2','value 3'); Input String $string = ' <table width="100%"> <tr> <td>Name:</td> <td>[replace]</td> </tr> <tr> <td>Date:</td> <td>[replace]</td> </tr> <tr> <td>Info:</td> <td>[replace]</td> </tr> </table> '; Desired Result <table width="100%"> <tr> <td>Name:</td> <td>value 1</td> </tr> <tr> <td>Date:</td> <td>value 2</td> </tr> <tr> <td>Info:</td> <td>value 3</td> </tr> </table>

  Read the article

• mysql query results sorting

  - by user329094

  I am calling the results form a query to a list on my site based on if the item is "downtown_hosted". This works fine but I would now like to sort that list DESC, but can't seem to get the syntax correct. Below is what I have: $result_events = mysql_query("SELECT * FROM events WHERE downtown='downtown_hosted' ORDER BY date DESC LIMIT 5 ");

  Read the article

• Subversion Branch Reintegration

  - by Aaron Smith

  When a branch is reintegrated to the trunk, is that branch effectively dead? Can you make modifications to the branch after the reintegration and merge those back into the trunk at a later date?

  Read the article

• How can I create dates/times and compare them in SQL?

  - by William

  I'm trying to create a BBS using PHP and SQL, and I want to make it so the topic with the most current post is on top of the topic list. what is a easy way to check if one date and time is more current than another?

  Read the article

• Python Split usage

  - by Chris M

  I'm cocking this up and it should be really simple but the value of sortdate is none (note im only doing this because converting a string to a date in Python is a bugger). DateToPass = str(self.request.get('startdate')) mybreak.startdate = DateToPass faf = DateToPass.split('-') sortdate = str(faf[2] + faf[1] + faf[0]) That should work? but its just being stored as null though the datetopass is being stored fine.

  Read the article

• Simple tool/steps for obfuscating/scrubbing production data

  - by Krishna Kumar

  I am involved in a project where I need to provide subset of our production data (for a date range) to one of my co-workers for trouble shooting.I would like to insert a scrubbed subset of the production data into a new database table that my co-worker can access. Please suggest best approach to achieve this.

  Read the article

• Is there a bash command to do this?

  - by user198729

  I want to know if new files/directories have been created in a specific directory A since a fixed date time. Is there a bash command to do this?

  Read the article

< Previous Page | 300 301 302 303 304 305 306 307 308 309 310 311  | Next Page >