Search Results

Search found 15061 results on 603 pages for 'modified date'.

Page 168/603 | < Previous Page | 164 165 166 167 168 169 170 171 172 173 174 175  | Next Page >

• Getting Two items from Same table in SELECT statment

  - by mouthpiec

  Hi, I an SQL SELECT statement I need to extract the name of two teams, taking both teams from the same table. Eg Below SELECT sport_activity_id, (team A), (team B), date, time FROM sportactivity, teams WHERE competition_id_fk = 2 For (team A) and (team B) I have an team_id, which is a FK for the table 'teams' Is it possible to get the following result from these tables by SQL? 1, Barcelona, Arsenal, 01/01/2000, 20:00 the two table are the following: table sportactivity sport_activity_id, home_team_fk, away_team_fk, competition_id_fk, date, time (tuple example) - 1, 33, 41, 5, 2010-04-14, 05:40:00 table teams team_id, team_name (tuple example) - 1, Algeria

  Read the article

• In Eclipse, how can I see all the code I've checked in this week? We use CVS

  - by Seth

  I'm using Eclipse 3.3.2 and CVS. Is there a way for me to see the code only I have checked in since some date? I know how to use "Compare With..." to see all the changes (anyone's code) since a particular version or date. Our team doesn't use Task Tags, could those help?

  Read the article

• Rename all files in a folder using batch

  - by user270506

  I would like to create a batch file to rename all the files with extension ".log" in a folder to append with today's date. For example : App.log will be appended to App.log06112010 where date is 06112010. Please suggest

  Read the article

• php strtotime() some help

  - by sea_1987

  Hi there, I am taking credit card details and I am taking the expiration date in two form field, one for the expiration month and one for the expiration year, I am wanting to store the expiration date as timestamp. Will strtotime("05/2010") create a time stamp or do I need to pass a day as well or is there an alternative? Thanks

  Read the article

• help with sql-server query - dates

  - by Gold

  hi i have this table: id|date 1 | 10/11/2009 2 | 13/11/2009 1 | 20/12/2009 3 | 21/12/2009 1 | 30/12/2009 if i stand on the last record (id=1) and i need to see the last date where id=1 is appear -- will show me: 1 | 20/12/2009 what query will do it ? thank's in advance

  Read the article

• How do you create a nested LINQ Grouping / Lookups for a Collection of Objects

  - by Jeff Windsor

  Given a list of objects with a date and decimal, I would like to index these objects by the year, month, dayofweek and hour of the date. In .NET 2.0, I would have created this graph using a set of nested dictionaries and a list as the leaf node. I am interested in how this could be done with LINQ.

  Read the article

• WHERE condition accross multiple rows

  - by Chris G

  I have this table... -------------------------------------- | user_id | status | status_date | -------------------------------------- | 1 | Current | 2012-08-01 | | 1 | Referral | 2012-03-14 | | 2 | Referral | 2012-04-23 | | | | | -------------------------------------- How would I query to find a distinct user_id who has a referral date before 2012-06-30 AND either a current date of after 2012-06-30 or no current status record at all? Database is MySQL.

  Read the article

• How do I use .find for the last five days in ruby on rails?

  - by Angela

  Have a model called contact_email.date_sent I want to be able to run a report which displays all those where the date_sent range is between date.today and date.today 5 days ago. I assume I use something like @send_emails = Contact_Email.find(:conditions=> ???) But not clear what exactly is the best way. Thanks!

  Read the article

• Split Java ArrayList by properties of contained Objects

  - by tzippy

  I have an ArrayList containing Objects that have a date value. Now I want to manage to create a new ArrayList for each year that contains all the Objects from the main ArrayList that have the same year in their date Value. So all Objects from 2010 go in one List, all from 1999 in another.

  Read the article

• Jquery datepicker icon hide

  - by Tony Borf

  I am using a Jquery dialog for both viewing a record and editing a record. When in edit mode the user can change the date using the datepicker. In viewmode I need to hide the datepicker icon and only show the date. Is there a way to toggle the datepicker icon on and off as needed?

  Read the article

• What will be the return status in the following sheel script.

  - by Pradip Bhojania

  i have two shell scripts: script1.sh echo "date : DATE" exit 0; script2.sh ./scripts1.sh if [ $? -eq 0 ]; then reboot; else echo "Failed" fi What should be the result. Ideally it should have been "reboot" , however on some execution i got the "failed" message too. Can anyone explain why this happens?

  Read the article

• How to set the format of dates in a web appication

  - by GigaPr

  Hi, i would like to set the date format of all the dates in my web application in a central location. i mean if the website is opened in USA it will have a format such as 3/19/2010 (March/19/2010) while in Italy will be 19/3/2010 (19/March/2010) i am no really concerned with how to locate the users but indeed on how to set the different date format for the whole application in one single location in c#.NET thanks

  Read the article

• How to change the way that timer schedules in TimerTask?

  - by Judking

  Here is the code snippet: Timer t = new Timer(); TimerTask task = new TimerTask() { @Override public void run() { //change the timer rate of scheduleAtFixedRate here } }; //every 10 sec t.scheduleAtFixedRate(task, new Date(), 10000); Could anyone tell me how to change the rate of timer to t.scheduleAtFixedRate(task, new Date(), 30000) in method run from TimerTask instance? Thanks a lot!

  Read the article

• webservice run automatically

  - by Abhisheks.net

  is there any trick to run a Webservice automatically to check some date specific and performs some operations on particular date. like sending birthday email's and so on ?

  Read the article

• Ubuntu Bash Script changing file names chronologicaly

  - by Manifold

  I have this bash script where I am trying to change all *.txt files in a directory to their date of last modification. This is the script: #!/bin/bash # Renames the .txt files to the date modified # FROM: foo.txt Created on: 2012-04-18 18:51:44 # TO: 20120418_185144.txt for i in *.txt do mod_date=$(stat --format %y "$i"|awk '{print $1"_"$2}'|cut -f1 -d'.'|sed 's/[: -]//g') mv "$i" "$mod_date".txt done The error I am getting is: renamer.sh: 6: renamer.sh: Syntax error: word unexpected (expecting "do") Any help would be greatly appreciated. Thank you for your time.

  Read the article

• Regex to compare 2 dates in javascript

  - by Alex

  Hello, is there a good regex expression that would be able to compare two dates like 3/27/2010 to 3/8/2010 to tell if the first date is greater then the second date? I'd like to compare using javascript

  Read the article

• MySQL grouping by a previously declared alias, what do I wrap it in? ' OR `

  - by cgmojoco

  I have an SQL query that has an alias in the SELECT statement SELECT CONCAT(YEAR(r.Date),_utf8'-',_utf8'Q',QUARTER(r.Date)) AS 'QuarterYear' Later, I want to refer to this in my group by statement. I'm a little confused...should I wrap this with backticks, single quote or just leave it unwrapped int he group by GROUP BY `QuarterYear ` or should I do this?: GROUP BY 'QuarterYear' or just this?: GROUP BY QuarterYear

  Read the article

• How to compare the year with the current year in iphone?

  - by Warrior

  I am new to iphone development.I am parsing a XML URL and display the title ,date and summary in a table view.I noticed some of the date were very old like "Wed, 31 Dec 1969 19:00:00 -0500" ,So i don't want to display the dates which are 1 year older than the current year.How to do that? I used the sample code from this site for parsing and display the details.Please help me out.Thanks.

  Read the article

• What's the best way to make a time from "Today" or "Yesterday" and a time in Python?

  - by sh1mmer

  Python has pretty good date parsing but is the only way to recognize a datetime such as "Today 3:20 PM" or "Yesterday 11:06 AM" by creating a new date today and doing subtractions?

  Read the article

• Get month in mm format in javascript

  - by Michael Kniskern

  How do I retrieve the month from the current date in mm format? (i.e. "05") This is my current code: var currentDate = new Date(); var currentMonth = currentDate.getMonth() + 1;

  Read the article

• PHP checking if two dates differs at least tree months

  - by user2301515

  In php how to check if one date (given as string) differs to another date at least tree month (unable to find any examples): $date1 = "2013-11-05"; $date2 = "2013-11-19"; //both dates is in form yyyy.mm.dd differsTreeMonths($date1,$date2) { ???? return $differs; } differsTreeMonths("2013-11-05","2014-05-02");//true differsTreeMonths("2014-01-01","2014-04-01");//true differsTreeMonths("2014-01-01","2014-03-31");//false differsTreeMonths("2013-12-01","2014-01-15");//false etc Thank you

  Read the article

• What is the best way to include a php file as a template?

  - by Jon

  I have simple template that's html mostly and then pulls some stuff out of SQL via PHP and I want to include this template in three different spots of another php file. What is the best way to do this? Can I include it and then print the contents? Example of template: Price: <?php echo $price ?> and, for example, I have another php file that will show the template file only if the date is more than two days after a date in SQL.

  Read the article

• How to convert a datetime value into a varchar with MM/dd/yyyy HH:MM:SS AM/PM format?

  - by Jyina

  I need to convert the below date into the output as shown. I can get the date part using the code 101 but for the time I could not find any code that translates the time to HH:MM:SS AM/PM? Any ideas please? Thank you! declare @adddate datetime Set @adddate = 2011-07-06T22:30:07.5205649-04:00 Convert(varchar, @adddate, 101) + ' ' + Convert(varchar, @adddate, 108) The output should be 06/07/2011 10:30:07 PM

  Read the article

• SQL Server - How Do I Substract 2 Hours from Formatted Time

  - by user1842653

  I need to know how to add 2 hours to the below 'Completed' timestamp. Here is the Select statement Select Tsk.task_id,Tsk.org_id,Tsk.completed,Tsk.assgn_acct_id,name FROM tdstelecom.tasks As Tsk WHERE Tsk.task_id = '11094836' AND DATE(Tsk.completed) < CURDATE() AND DATE(Tsk.completed) >= DATE_SUB(CURDATE (),INTERVAL 180 DAY) Here are the results: 2012-08-22 14:18:14 Desired results: 2012-08-22 16:18:14

  Read the article

• Modify an exact line number of a text file and add certain string after the end of the line

  - by Werner

  Hi, given a plain text file, how can I do, using bash, awk, sed, etc, to, at the line number NLINE, add the string STR, just n spaces after the end of the line? So, for instance, if this is the line NLINE: date march 13th for 5 spaces, we get date march 13th STR and one gets the modification in a new file. Thanks

  Read the article

< Previous Page | 164 165 166 167 168 169 170 171 172 173 174 175  | Next Page >