Search Results

Search found 8550 results on 342 pages for 'datetime operation'.

Page 31/342 | < Previous Page | 27 28 29 30 31 32 33 34 35 36 37 38  | Next Page >

• Oracle get previous day records

  - by Phill Pafford

  Ok I think I'm getting the previous year instead of the previous day, but I need to previous day. SELECT TO_DATE(TO_CHAR(CURRENT_DATE, 'YYYY-MM-DD'),'YYYY-MM-DD') - 1 FROM Dual I'm comparing it to a datetime stamp in this format and wish to get all the rows from the previous day. YYYY-MM-DD HH:MM:SS So I'm trying something like this SELECT field,datetime_field FROM database WHERE datetime_field > TO_DATE(TO_CHAR(CURRENT_DATE, 'YYYY-MM-DD'),'YYYY-MM-DD') - 1

  Read the article

• Filtering by date with DataTable.RowFilter while ignoring time

  - by Sam

  How do I filter for records on a DataTable which are on a certain date? I've tried plain [datecol] = #11 March 2010# and CONVERT([datecol],'System.DateTime') = #11 March 2010#. With no luck. MSDN: RowFilter Expression Syntax Solution [datecol] >= #11 March 2010 00:00# AND [datecol] <= #11 March 2010 23:59:59#

  Read the article

• how can i get milliseconds with a date

  - by vakas

  i am trying this Datetime t=Convert.ToDateTime(row["TimeStamp"]) i am getting this record from Database dat contains the milliseconds too but when i do this i lose the milliseconds how can i get the milliseconds

  Read the article

• Determine Whether Two Date Ranges Overlap

  - by Ian Nelson

  Given two date ranges, what is the simplest or most efficient way to determine whether the two date ranges overlap? As an example, suppose we have ranges denoted by DateTime variables StartDate1 to EndDate1 and StartDate2 to EndDate2.

  Read the article

• JODA time in Java Appengine

  - by aloo

  Has anyone gotten JODA time classes to work on Google Appengine? I'm using 1.3.4 of the java sdk and I get the following error when trying: java.lang.NoClassDefFoundError: com/google/appengine/repackaged/org/joda/time/DateTimeZone I've imported it as well: import com.google.appengine.repackaged.org.joda.time.DateTime;

  Read the article

• Using MVC2, how do I validate that a date is within a given date range?

  - by Andy Evans

  I have a requirement, in an MVC2 web application, to validate that the user is at least 13 years old. Is there a date/datetime validation attribute that will enable me to do this?

  Read the article

• Determine if it has been 6 months since birthday in c#

  - by Longball27

  Hi, Sorry if this is a duplicate, but i think I've seen enough of Google for one day! My application needs to adjust a clients current age by +0.5 if it has been 6 months since their birthday. The code should look something like this, but how many ticks would there be in 6 months? if (DateTime.Today - dateOfBirth.Date > new TimeSpan(6)) { adjust = 0.5M; } else { adjust = 0M; } Thanks in advance

  Read the article

• Creation date column in SQL table

  - by MatsT

  What is the easiest way to automatically fill a datetime column in an SQL data table with the date the row was created? Using SQL Server 2005 if that matters.

  Read the article

• Searching temporal data

  - by user321299

  I developing an application (in C#) where objects are active under a period of time, they have from and to properties of DateTime-type. Now I want to speed up my search routine for queries like: Are there other active objects in this timeperiod/at this time. Is there any existing temporal index I can use or can I use QuadTree/other tree-structures to search in an efficient way.

  Read the article

• Parameter has no walue

  - by Simon

  string queryString = "SELECT SUM(skupaj_kalorij)as Skupaj_Kalorij " + "FROM (obroki_save LEFT JOIN users ON obroki_save.ID_uporabnika=users.ID)" + "WHERE users.ID= " + a.ToString() + " AND obroki_save.datum =?"; using (OleDbCommand cmd = new OleDbCommand(queryString,database)) { cmd.Parameters.Add("@datum", OleDbType.Char).Value = DateTime.Now.ToShortDateString(); } Why doesn't the parametr datum get the date value? (the value of at least one complex parameter has not been determined )

  Read the article

• [r] Converting unix seconds in milliseconds to POSIXct/POSIXlt

  - by signalseeker

  Why do I see a difference when I convert a unix timestamp to datetime object in R? > as.POSIXlt(1268736919, origin="1970-01-01", tz="America/New_York") [1] "2010-03-16 06:55:19 EDT" > as.POSIXct(1268736919, origin="1970-01-01", tz="America/New_York") [1] "2010-03-16 11:55:19 EDT" The result from POSIXlt is actually correct. Also, is there a way to do this conversion without specifying the origin? Thanks

  Read the article

• C#: Return start and end of year given any month.

  - by abmv

  I need two or one (out) C# method that will take any datetime and return the start date of year and end date of year for that year. Not a homework (;-)

  Read the article

• Display date _and_ time in user locale

  - by Sverre Rabbelier

  I know I can use android.text.format.DateFormat.getDateFormat() to format my dates, and android.text.format.DateFormat.getTimeFormat to format my times, but how do I format a datetime? Similar to the getDateTimeInstance method from java.text.DateFormat. I'm currently just concatenating the result of both the getDateFormat and getTimeFormat's formatters, but I don't know which way around the user prefers to have their dates and times shown.

  Read the article

• Parameter has no value

  - by Simon

  string queryString = "SELECT SUM(skupaj_kalorij)as Skupaj_Kalorij " + "FROM (obroki_save LEFT JOIN users ON obroki_save.ID_uporabnika=users.ID)" + "WHERE users.ID= " + a.ToString() + " AND obroki_save.datum =?"; using (OleDbCommand cmd = new OleDbCommand(queryString,database)) { cmd.Parameters.Add("@datum", OleDbType.Char).Value = DateTime.Now.ToShortDateString(); } Why doesn't the parameter datum get the date value? (the value of at least one complex parameter has not been determined )

  Read the article

• WPF4 DatePicker - adding time

  - by Chris

  Now that there is an official MS DatePicker in WPF4, I was wondering if there was a way to let it edit the Time part of a DateTime as well. I can't see anything, but it seems rather obvious to have missed out?

  Read the article

• Using client time to calculate timezone

  - by Mike TK

  Hi Folks, Instead of asking a client timezone in registration form (to correctly format datetime, all server dates in UTC) I thought about fetching a time from client computer and calculating time offset between client and server. Anyone tried this? How often clients have something insane on their system clocks? Cheers!

  Read the article

• Does python have a session variable concept???

  - by gizgok

  I have a datetime.date variable in python.I need to pass it to a function do operations according to the date given and then increment the date for the next set of operations.The problem is I have to do the operations in diff pages and hence I need the date as a variable which can go from page to page. Can we do this in python.......

  Read the article

• Format date on x-axis in cfchart

  - by dmr

  I want to format the date on the x-axis of my cfchart as mm/yyyy as opposed to the full datetime value that is returned from sql server (yyyy-mm-dd hh:mm:ss). How do I do this?

  Read the article

• Date time formate problem in c#

  - by jestges

  Hi I'm working with c# simple application to display system date time. textbox.Text = DateTime.Now.ToString("MM/dd/yyyy"); but it is showing result as : 05-12-2010 What is the problem with this code? or do I need to change any where in the regional settings of my machine. thank you

  Read the article

• Javascript timezone solution needed

  - by user198729

  I have unix timestamps from time zone X which is not known, the current timestamp(now()) in TZ X is known 1275143019, how to approach a javascript function so that it can generate the datetime in the users current TZ in the format 2010-05-29 15:32:35 ?

  Read the article

• Recursive SQL, have the last three values increased?

  - by Mike

  Hi, I have a table that looks like this: ---------------------- | DateTime | Value | ---------------------- | 2010-01-01 | 26 | | 2010-02-01 | 24 | | 2010-03-01 | 23 | | 2010-04-01 | 28 | | 2010-05-01 | 30 | I need to find if the last three consecutive months have increased in value. How can I get SQL to check whether the value for each has increased? If anyone can give me any pointers for solving this problem it would be greatly appreciated! Thanks

  Read the article

• Mysql - NOW() function calling

  - by Ockonal

  Hello, I'm using php for making queries for mysql. Here is one: UPDATE `subscribers` SET `curDate` = NOW() WHERE `e_mail` = "$resEmail" curDate - DateTime type. The problem is that after this query curDate of given email is 0000-00-00 00:00:00 What's wrong?

  Read the article

• Is there a better way to format this date string

  - by Mark Breen

  Hello is there are better way to structure this line of code, as you can see, I am changing the format of a string that contains a date. lblCourseStartDate.Text = String.Format("{0:D}", DateTime.Parse(CourseStartDate)); I just found it untidy that I am converting twice or three times to get the format I want. Thanks

  Read the article

• Formatting dates when serialising an object in C# (2.0)

  - by zoman

  Hi, I'm xml-serializing a object with a large number of properties and I have two properties with DateTime types. I'd like to format the dates for the serialized output. I don't really want to implement the ISerializable interface and overwrite the serialization for every property. Is there any other way to achieve this? (I'm using C#, .NET 2) Thanks.

  Read the article

• store Current Date & time in MySql Using ASP.net

  - by Khilen

  I want to store the current date & time which can be get by System.DateTime.Now in asp.net but while storing in Mysql it gives Error of Invalid Time.

  Read the article

< Previous Page | 27 28 29 30 31 32 33 34 35 36 37 38  | Next Page >