i have image table, which has 2 or more rows with same date.. now im tring to do order by created_date DESC, which works fine and shows rows same position, but when i change the query and try again, it shows different positions.. and no i dont have any other order by field, so im bit confused on why its doing it and how can i fix it. c...
how in lamp (LINUX ,APACHE ,MYSQL ,PHP) environment , can i show date and time in web page according to the user time zone ? THANKS ...
How can I add two dates in Java? Example: The sum of "2010-01-14 19:16:17" "0000-10-03 01:10:05" would result in "2010-11-17 20:26:22". I know how to do it using Calendar and adding field by field. Is any other way to sum them all (year/month/day/hour/minute/second) at once? ...
I think this is a really, really simple question but I can't seem to find the answer. I'm trying to set default values for properties in a PHP class and one of them is a date so I'm trying to use the date() function to set it: <?php class Person { public $fname = ""; public $lname = ""; public $bdate = date("c"); publ...
Client compiled with OCI: 10.2.0.4.0 Server: Oracle9i Enterprise Edition Release 9.2.0.4.0 The problematic query is: SELECT CODIGO FROM LOG WHERE TEL = :telnumber AND DATE_PROC = '05-JUL-08' Table description: SQL>describe LOG; TEL NOT NULL VARCHAR2(15) CODIGO NOT NULL VARCHAR2(20) DATE_PROC NOT NULL DATE As simple as it might loo...
Hi everyone, I'm trying to select a date range using SQL and I've come across a few issues: When I run something along the lines of: SELECT ... as edate ... WHERE edate BETWEEN To_Date('10/15/2010', 'MM/DD/YYYY') AND To_Date('10/15/2011', 'MM/DD/YYYY') it will come back with a ORA-01848: not a valid month . The tab...
I'm trying to figure this out on and off for some time now. I have a bash script in Linux environment that, for safety reasons, I want to prevent from being executed say between 9am and 5pm unless a flag is given. So if I do ./script.sh between 9am and 5pm it would say "NO GO", but if I do ./script.sh -force it would bypass the check. Ba...
I have the start date and the end date. I need to iterate through every day between these 2 dates. What's the best way to do this? I can suggest only something like: Date currentDate = new Date (startDate.getTime ()); while (true) { if (currentDate.getTime () >= endDate.getTime ()) break; doSmth (); currentDate = new Da...
How to check whether the given date is earlier than a month ago? What is the fastest algorithm? I have to take into account that different months have different numbers of days. ...
currently the output from my date field entries reads like this Sun, 25/04/2010 - 10:00am - Sun, 02/05/2010 - 5:00pm but I would prefer it to read like this Sun, 25/04/2010 - Sun, 02/05/2010 10:00am - 5:00pm is there a drupal beginner way of doing this? ...
ID | Date | Status | Physician ID 44397479 10/13/2009 17:40 NOSHOW 44397480 10/13/2009 16:40 CHECKED OUT 108 44397481 10/13/2009 14:32 CHECKED OUT 108 44397482 10/14/2009 10:44 RESCHEDULED 108 44397483 8/26/2009 12:35 RESCHEDULED ...
Why is PHP date("W") showing that the current week is 2? Shouldn't it be on week 3? In the PHP documentation it says: weeks starting on Monday. Does that mean it just ignored the first 3 days of this year? ...
I am working on a project that involves converting data into dos date and time. using a hex editor (Hex Workshop) i have looked through the file manually and and found the values I am looking for, however I am unsure how they are calculated. I am told that the int16 value 15430 corresponds to the date 06/02/2010 but i can see no correlat...
In this table I store changeable values for certain spids. As days go by, these values can change, and an spid can get a new value. Now I want to find out until when a certain value is enabled. This is the data for a single spids uid spid propertyvalue creationdate -------------------------------------------------- 1 3 ...
Hi I have an oracle db and I need a table containing all the dates spanning 2 years; for example from 01/01/2011 to 01/01/2013. First I thought of a sequence but apparently the only supported type is number, so now I am looking for an efficient way to do this cheers hoax ...
I'm trying to validate date using PHP. I'd like following formats to be valid: d/m/yy d/m/yyyy dd/m/yy dd/m/yyyy d/mm/yy d/mm/yyyy dd/mm/yy dd/mm/yyyy I've tried many regular expressions and different variations of checkdate() function. Currently I have something like this: function _date_is_valid($str) { if(strlen($str) == 0) ...
Hi all, I am trying to create a function on javascript to bring the date from my database in format (yyyy-mm-dd) and display it on the page as (dd/mm/yy). I would appreciate any help. Thanks. PD: Let me know if you need more clarification. ...
HI all, I got a JavaScript function to convert the date, but I was wondering if there is any way to convert the date with xsl without using JavaScript. Thanks. ...
I am currently writing a Delphi application that runs queries over a DB2 database using ADO. One of the requirements is that the user should be able to define queries using dates, for example "show me all data from the last 60 days" or "show me all data between November 20th 2009 and January 18th 2010". This wouldn't be an issue, excep...
Note: In the MySql database, "dob" is varchar and in this format: mm/dd/yyyy Date of birth, Cvrg Effective Date, & Cvrg Expiration Date need to be changed from mm/dd/yyyy to yyyymmdd when it arrives in excel. Any help is greatly appreciated. Please see the code below: <?php if($qry == "ok"){ // get db connection inc...