341 Topics
 | |
| | I am having a bit of difficulty in getting the right value. What I want to query is, the users who expire in 7 days, for example on 4th Oct 2011, the query should display the result of that particular day only. Right now I am querying as below: select … |
| | Hi all. As a hobby I've been working on making a website with PHP and MySQL, both of which I am new to. I'm having some trouble with the comments system as I can't seem to be able to insert a date into the database. After the "insert", when I …  |
| | Hello there, I am having trouble with my C# datagrid. Im working with sql. I have four columns in my datagrid: firstname, lastname, membership, date. So heres the design behind my app. Employee scans a card, hits update. Info pertaining to that member gets pulled from the sql database, then …  |
| | hi, i need to subtract one date form the other and take the difference in minutes or seconds.. i'm getting the first date from the data base in 'Y-m-d H:i:s' format and second date is the current date (same format). and i want to know the difference between them in … |
 | Hey all =] , I am having a few problems ending this coding homework and i would love if you could help me on how to solve this problem, well my problem is that i try to print the toStirng in my constructor class and for the months it prints … |
| | i have a date column where dates are saved in varchar format like this 17-03-2011 :: 11:19:48 i want to find last date through query.. please help thanks |
| | i have two DatePickers on form and I want filter between two dates. So when i click search in lsitview display the dates between can anyone tell me how to deal with? |
| | [CODE]import java.text.DateFormat; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.Date; import java.util.Calendar; public class CheckIn{ Date today; void getArrivalDate() { DateFormat df = new SimpleDateFormat("dd/MM/yyyy"); try { System.out.print("Enter Date in dd/mm/yyyy format: "); String d = Keyboard.readString(); today = df.parse(d); df.format(today); } catch (ParseException e) { e.printStackTrace(); } } void getDepartureDate(){ Calendar … |
| | I have a date picker that give me this result: e.g. 2011-29-08 When it is inserted in mysql, it outputs '0000-00000'. What can I do? I know "strftime("%Y-%m-%d %H:%M:%S", time());" But I have no timestamp to put as an argument. The only data I can use is the data that … |
| | I need the dates in a specific range.And i want to get the result in java manipulating from a MySQL database.Now how can i do so. Suppose there are 3 days 17.08.2011,18.08.2011 and 19.08.2011 .I want the dates in the range 16.08.2011 to 18.08.2011 .So how can i manipulate it … |
| | I made a program and want to enter previous dates into a linkedList. My code is [CODE]package bowlinggame; import java.util.Date; import java.util.LinkedList; import java.util.TreeSet; public class BowlingGame { public static void main(String[] args) { TreeSet <String>PlayerNames = new TreeSet<String>(); PlayerNames.add("Steve"); PlayerNames.add("James"); PlayerNames.add("Bob"); for (Object o : PlayerNames) { System.out.println(o); } …  |
| | Hello there, I need some help with a query .. Table gamedate cutofftime 2011-08-25 13:55 I want to list games that are today +7 days but today games where the cutoff time has passed should not be displayed. Can anyone help me with this query please. Thank you for any … |
| | Hello, I've got a script of facebook date but I want to translate the returning day into my language (Monday=>mmday for instance). Could you guy please. [CODE]function fb_date($timestamp){ $difference = time() - $timestamp; $periods = array("second", "minute", "hour"); $ending=" ago"; if($difference<60){ $j=0; $periods[$j].=($difference != 1)?"s":""; $difference=($difference==3 || $difference==4)?"a few ":$difference; … |
| | Hello Gurus, I have a table that holds one date field and one time field. The formats are 2011-12-01 and the time field format is 22:55:01 I want to compare a string "2011-12-01 22:58:00" to the date and time field of the table, without having to take the string apart. … |
| | I have a Database that stores a residentID, apartment, MoveInDate, and MoveOutDate. I am trying to run a query from this database to find the resident row where the MoveOutDate is NULL so I can enter the date they moved out. My Coldfusion is not the best and here is … |
 | Hello, What I am trying to do is restrict access to something if 48 hours hasn't passed since the last access. I have a MySQL table with the last access time (col name: lastAccess). If they are within the 48hours, deny access and tell them how many hours and minutes … |
| | I have a monthly fee collecting table. I need to store year and month only for that purpose. For example just like to store, John has done the payment for 2010 July. I thought of using a DATE field for this. I can store the year and month with valid … |
| | Hi Frendz, I have datetime field in database. now i want to filter out the record which are in today date using mysql query? |
| | Please help on the multiple textbox as date in mysql [CODE] <input type="text" name="date" class="f_input input1" style="width:32px;" value="D" maxlength="1" onBlur="if(this.value=='') this.value='D'" onFocus="if(this.value =='D' ) this.value=''" > <input type="text" name="date" class="f_input input1" style="width:32px;" maxlength="1" value="D" onBlur="if(this.value=='') this.value='D'" onFocus="if(this.value =='D' ) this.value=''" > <input type="text" name="date" class="f_input input1" style="width:32px;" maxlength="1" value="M" onBlur="if(this.value=='') … |
| | Hi, I have a csv datafile with stock price data that I've read into a vector of structures that looks like this: 09/11/2009 9.30 open, high, low, close, volume 09/11/2009 9.31 o, h, l, c, volume and so on to 09/11/2009 16.14 o, h, l, c, volume //next day starts …  |
| | I have a Textbox named txtage.text.Now I want When Insert in txtage.text as 30/12/1980. disable tabindex.and messagebox show "You can not give admission".If Insert in txtage.text as 30/12/2005. Enable Tab index .its mean student 's age must be 6 year not greater nor less. |
 | I'm trying to create a message board where members can post messages to other members. I'd like to have a section where it says "4 posts since Jan 2011" just like DaniWeb does. How do I get the date from the [CODE]"first row WHERE user='username'"[/CODE] with PHP & MySQL? Also, … |
 | This have been a problem to me for long now and I want to settle it once and for all. PHP and MySQL DateTime and date fields have been headache to me. Suppose I have fields ------Name--------------BirthDate--------LastTimeYouAte-- ------VARCHAR(255)------DATE-------------DATETIME-------- Now, When I do insert, How do I format PHP Date and … |
| | Im in need of big help... (sorry bout the size of the post :$) Im just getting started in databases and need some magic.... Im running on the server; * Apache/2.2.17 (Win32) mod_ssl/2.2.17 OpenSSL/0.9.8o PHP/5.3.4 mod_perl/2.0.4 Perl/v5.10.1 * MySQL client version: mysqlnd 5.0.7-dev - 091210 - $Revision: 304625 $ * …  |
| | I have a silly question for you guys.i am running a java program [CODE]public class manish { public static void main(String s[]) { Date d=new Date(); System.out.println("Date is"+d.toString()); } } [/CODE] while i running this on RHEL 5.2 i am getting this output Date isFri Jul 08 10:55:30 IST 2011 …  |
| | Is there a way to get current date and time from remote windows machine on linux? On remote windows machine ssh not enabled, there are no powershell. Can we achieve result via telnet or smbclient? |
| | |
| | ive already get the previous date but i dont know how can skip the weekend date.. example,,i run the application on monday the generated data must be the date on friday,,it must skip tsaturday and sunday,,i cant find similar problem in net,,plllzzz help... |
| | Hello, Could someone help me with this question that I need to complete within 4 days? I have a problem with the insert statment on the code below. This code is working fine by inserting the ststement, but the problem is that the DATE is not being inserted into the … |
| | The date stored in my db is in the following format: 2011-06-10 17:15:26.000 2011-06-10 17:15:27.000 2011-06-10 17:15:28.000 2011-06-10 17:15:29.000 However I intend to retrieve the date above using the format below: 2011-06-10 How is it done? Your help is kindly appreciated. |
The End.