Search Results

Search found 12994 results on 520 pages for 'date diff'.

Page 59/520 | < Previous Page | 55 56 57 58 59 60 61 62 63 64 65 66  | Next Page >

• save Date Number in PHP variable.

  - by Denoteone

  This question goes along with another one of my post that I already accepted How do I get the "date number" in php 2010-08-24 20:00:00.000 I want to assign the current date number to a variable $current_date_num so I can use it in my query to compare what is already in the database. $query ="SELECT * FROM Reservations WHERE [Room_ID] = '$field' AND [Meeting Start] > '$current_date_num' ORDER BY [Meeting Start] asc ";

  Read the article

• How to find hte day of a Date

  - by sijith

  Hi, I want to find the day of a particular date in QT. ex: 1/05/2010 is Sunday. IS it possible to find day using date

  Read the article

• how to find end of quarter given a date in the quarter

  - by Ramy

  If i'm given a date (say @d = '11-25-2010'), how can I determine the end of the quarter from that date. I'd like to use a timestamp one second before midnight. I can get this: select dateadd(qq, datediff(qq, 0, getdate()), 0) as quarterStart which gives me: '10-1-2010' and I use this for one second before midnight of a given day: select DateAdd(second, -1, DateAdd(day, DateDiff(day, 0, @d))+1, 0) ) AS DayEnd in the end, a quarterEnd method would give me '12-31-2010 23:59:00'

  Read the article

• Adding Date to Excel using Open XML

  - by Ant

  Hi, I would like to insert Date value to excel file using Open XML. Here is my code sample. cell.CellValue = new CellValue(value.ToString()); cell.DataType = new EnumValue<CellValues>(CellValues.Date);

  Read the article

• Can I get a patch-compatible output from git-diff?

  - by Malvolio

  I am doing something very simple wrong. I'm trying to prepare an ordinary patch file, so I can reapply some changes: $ git diff > before $ git diff something_here > save.patch $ git checkout . $ patch < save.patch $ git diff > after $ diff before after $ With something_here blank it almost works, but the file names aren't right. I think I'm just I'm missing some option. In real life, I am going to do a merge after the checkout, so the patch might fail there, but you see what I'm getting at.

  Read the article

• strotime() returning false on proper date formatted string?

  - by eriksays

  Trying to format a date string using a technique I've used countless times, suddenly returning false (PHP5). Anyone run into this? //$new_date = June 14,2010 echo $new_date; $new_date = date("F j, Y", strtotime($new_date)); //returns the infamous December 31, 1969 because strototime() is returning false?

  Read the article

• Inline in aspx, stripping date off of datetime

  - by DJGray

  I think if I just show you the following what I'm asking will make sense. In a link in my aspx, this works: ' title='<%# Container.DataItem["EventTime"].ToString() But the above contains the date portion of the string. This does not work (nor does any variant of it): ' title='<%# Container.DataItem["EventTime"].ToString("hh:mm:ss tt", CultureInfo.InvariantCulture) % Evantually, we want the title/hover for the link to read something like "4:30 PM : @Forbes Field" Everything is working with the exception of the 1/1/1900 being in front of the 4:30 How do I get the date off that EventTime datetime field?

  Read the article

• Add number of days to a date and calculate the end date?

  - by user355911

  How can I calculate the number of days from a specific date?in other words add number of days to a date. I looked up NSCalendar and NSdate and could not find anything specific to that regards.

  Read the article

• LINQ TO SQL, Dynamic query with DATE type fields

  - by acanthus

  Hello, I'm building a query with the LINQ dynamic library so I don't know how many potential parameters will I have and I get an error when trying to query DATE type fields: Operator '=' incompatible with operand types 'DateTime' and 'String' When I step through the debugger in the Dynamic.cs it shows that the value is of type string and the field is of type date so the problem is obvious but I have no idea how to approach it. Any ideas? BR

  Read the article

• How to Open a Directory Sorted by Date?

  - by xarzu

  How to Open a Directory Sorted by Date? In C#, I can open a directory for reading each file. How to I make sure that the directory I investigate in my C# code is opened such that it is sorted by last modified date?

  Read the article

• converting 10 digits to date and time format

  - by magdy

  I've a table field consists of 10 digits expresses the date and the time.. I want to extract a report where the date/time field can be readable from this field

  Read the article

• Convert a date string to a Unix timestamp

  - by Maxsy

  I have this date "Mon Mar 15 20:51:18 +0000 2010". How do i convert this date into a Unix timestamp?

  Read the article

• How to find out what the date was 5 days ago?

  - by Lost_in_code

  Well, the following returns what date was 5 days ago: $days_ago = date('Y-m-d', mktime(0, 0, 0, date("m") , date("d") - 5, date("Y"))); But, how do I find what was 5 days ago from any date, not just today? For example: What was 5 days prior to 2008-12-02?

  Read the article

• javascript date increment

  - by Muahmmad nadeem

  I want to set a text box with a date (in dd/mm/yyyy format) 14 days ahead to current date in javascript . can any one help me regarding this ?

  Read the article

• Mysql query for within a specific date

  - by Ajith

  I need to retrieve data from within a specific date range.Anybody can help me to create a query to getting the information within date range 12-12-2009 to 12-15-2009 from a mysql table.(including 12 and 15)

  Read the article

• How to get customised date format for Notification expanded view

  - by android_novice

  If i got a new message, in notification expanded view it shows only time. suppose If i got a message today(i.e on 06/06/2010) it should display simply a string "Today" and tomorrow it should show date on whilch message was received i.e it should display date 06/06/2010

  Read the article

• On Update: Auto Update Date/Time Field

  - by Abs

  Hello all, Is there an equivalent of MySQLs on update field for SQL server? With both DEFAULT CURRENT_TIMESTAMP and ON UPDATE CURRENT_TIMESTAMP clauses, the column has the current timestamp for its default value, and is automatically updated. What I am looking for is to have a date/time field and every time I update a record it updates the field with the date/time it was updated automatically? If it doesn't exist, I guess I'll have to go manual. Thanks all

  Read the article

• Mysql date : 0000-00-00 00:00:00

  - by jasmine

  In my query: $cselect = mysql_real_escape_string($_POST['cselect']); --------------- --------------- $sql = sprintf("INSERT INTO content (id, catID, title, abstract, body, status, published, date, description_meta, keywords_meta) VALUES ('', '%s', '%s','%s','%s','%s','%s','%s','', '' )", $cselect,$chead, $cabst,$ctext, $cp, $cradio, 'TIMESTAMP: Auto NOW()'); ouptput for date is: 0000-00-00 00:00:00. What is wrong in my query? Thanks in advance

  Read the article

• With JS add default date on TextBox

  - by senzacionale

  <asp:TextBox ID="txtDate" runat="server" AutoPostBack="true" OnTextChanged="txtDate_TextChanged"></asp:TextBox> how can with Jquery add default date. I do not know where and when to call this code: function addDefaultDate() { if ($('#txtDate').val().length == 0) { var now = new Date(); $('#txtDate').text(now.getDate() + '.' + now.getMonth() + '.' + now.getYear()); } }

  Read the article

• Date difference in SQL Server 2005

  - by naveen

  Hi, I have two dates of the form Start Date: 2007-03-24, End Date: 2009-06-26 Now I need to find the difference between these two in the below form: 2 years, 3 months and 2 days Can someone please … in SQL Server 2005

  Read the article

• insert date to oracle

  - by Gold

  hi i have 2 Date field's in oracle 10g (MyDate and MyTime) and i need to insert string that contain a date & time strDate = 04/01/2010 00:00:00 strTime = 01/06/2010 17:20:12 how to insert strDate & strTime to field's MyDate & MyTime

  Read the article

• Create a query that only shows active records based on start date, duration, and true/false

  - by Chris

  I'm trying to piece together a dynamic view that will give a list of all emails that are still being rejected. Table structure: EmailName - varchar(150) - An email address StartRejection - Date - Day to start rejecting email Duration - Small Int - Duration of rejection IsIndefinate - Bit - Is the rejection 'non date range specific' but indefinate

  Read the article

• Order and group by date in Mysql

  - by Alexd2

  Hi all and thanks in advance. I have a small problem which can not resolve, I have this table, and I want to sort by date and group it (but I only show 1 per idCAT) | id | idcat | name | date | | 1 | 3 | xx | 2011-01-02 | | 2 | 4 | xf | 2011-01-02 | | 3 | 3 | cd | 2011-01-01 | | 4 | 1 | cg | 2011-01-04 | | 5 | 4 | ce | 2011-01-06 | would like to stay that way, try in a way but I can not | 2 | 4 | xf | 2011-01-01 | | 3 | 3 | cd | 2011-01-02 | | 4 | 1 | cg | 2011-01-04 |

  Read the article

• Javascript function to add X months to a date

  - by George

  Is there a built in equivalent to the .NET framework's DateAdd or AddMonths functions? I'm looking for the easiest, cleanest way to add X month to a Javascript date. I'd rather not handle the rolloing over of the year as done here. or have to write my own function as done here. Is there something built in that is as nice as the .NET Date.AddMonths function? Or something close?

  Read the article

• Problem setting custom request header "Date" in Opera

  - by Solled Scroll

  I can set any other headers but not "Date". request.setRequestHeader("hi", "world"); works but request.setRequestHeader("Date", "today"); does not. That is in Opera.

  Read the article

< Previous Page | 55 56 57 58 59 60 61 62 63 64 65 66  | Next Page >