Search Results

Search found 12096 results on 484 pages for 'to date'.

Page 49/484 | < Previous Page | 45 46 47 48 49 50 51 52 53 54 55 56  | Next Page >

  • inserting only date in a column in sql server

    - by sam
    hi! Is there a way to insert only date in a datetime column in sql server without the time? for example date (datetime) =============== 12-01-2000 16-02-2000 or i should store this as a varchar and cast it when retriving so that i can convert to whatever form i need.

    Read the article

  • Calculating end date while skipping holidays + Joda time

    - by picca
    I would like to calculate end date (and time) of an event. I know starting date and duration (in minutes). But: I have to skip holidays - non-recurrent situation I have to skip weekends - recurrent situation I have to not count working time (e.g: from 8:00am till 5:00pm) - recurrent situation, but with finer granularity Is there a simple way

    Read the article

  • Add months to a date using jQuery

    - by hminaya
    I have a simple MVC form with the following elements: <%= Html.TextBox("FechaInicio") %> Which has the start date. <%= Html.TextBox("Meses") %> Which has the amount of months I want to add. I'd like to take the date that has been entered on the first textbox, add the amount of months that have been entered on the second textbox

    Read the article

  • Javascript date comparison

    - by Art
    Why does equality operator return false in the first case? var a = new Date(2010, 10, 10); var b = new Date(2010, 10, 10); alert(a == b); // <- returns false alert(a.getTime() == b.getTime()); // returns true Why?

    Read the article

  • c# Column datatype Date type (NOT DateTime)

    - by Sha Le
    Hi All: I want know is there good way to detect Column DataType for Date field (NOT DateTime)? This what currently I do: switch (dt.Columns[col].DataType.FullName) { case "System.DateTime": formatedVal = Formatter.GetDateTime(val); break; // which is NOT possible, but something equivalent am looking for

    Read the article

  • 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] =

    Read the article

  • Sorting Files into Subfolders based on EXIF Date

    - by honestor
    I have a huge directory from a HDD recovery that contains 70000+ JPEG files. I tried playing around with some AppleScripts, that I found, but had no luck. I already installed EXIFtool, which might be useful for this task. The current directory structure is as follows: dir001 - file0001.jpg ... - file9999.jpg dir002 - file0001.jpg ... -

    Read the article

  • How to get only the date from the sql server

    - by Pradeep
    this is what i want. but i have put only a specified date. SELECT BookName, Author, BookPrice FROM Book WHERE Book.Book_ID = ( SELECT Book_ID FROM Temp_Order WHERE Temp_Order.User_ID = 25 AND Temp_Order.OrderDate='3/24/2010' ) this is the date function i used. but it takes the time also. how to stop it. please help me

    Read the article

  • Linq grouping question

    - by Mike C.
    I have the following objects in a collection: Transaction: Type = "Widget" Date = "3/1/2011" Name = "Foo" Transaction: Type = "Widget" Date = "3/4/2011" Name = "Bar" Transaction: Type = "Gadget" Date = "3/2/2011" Name = "Baz" Transaction: Type = "Gizmo" Date = "3/1/2011" Name = "Who" Transaction: Type = "Gizmo" 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

    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

    Read the article

< Previous Page | 45 46 47 48 49 50 51 52 53 54 55 56  | Next Page >