Search Results

Search found 3379 results on 136 pages for 'datetime'.

Page 22/136 | < Previous Page | 18 19 20 21 22 23 24 25 26 27 28 29  | Next Page >

• Selecting rows from DataTable by DateTime column (hours)

  - by nCdy

  DatarowsForOneDay = dt.Select( dt.Columns[0].Caption + "='" + x.ToString("dd/MM/yyyy HH") + "'"); doesn't work, but DatarowsForOneDay = dt.Select( dt.Columns[0].Caption + "='" + x.ToString("dd/MM/yyyy") + "'"); works. So how can I select the date with a same hour? Variable x type is DateTime.

  Read the article

• Set time part of datetime variable to 18:00

  - by maxt3r

  Hi. I need to set datetime variable to two days from now but it's time part must be 18:00. For example if i call getdate() now i'll get 2010-05-17 13:18:07.260. I need to set it to 2010-05-19 18:00:00.000. Does anybody have a good snippet for that or any ideas how to do it right?

  Read the article

• DB2 timestamp PHP DateTime

  - by Dolfa

  After upgrade to PHP 5.3 my application is returning DB2 columns with Timestamp type as "2010-12-15-10.23.22.716000". This is causing problem for PHP DateTime function, as it fails with Failed to parse time string (2010-12-15-10.23.22.716000) at position 25 (0): Unexpected character It seems its having a problem with too much accuracy in DB2…

  Read the article

• DateTime group by date or hours

  - by nCdy

  01.02.2010 0:00:00 - 01.02.2010 anytime 01.02.2010 0:00:00 - 01.02.2010 0:any minutes and seconds so here is my date : DateTime x; it's 01.02.2010 0:00:00 as a string x.Date.ToString() here I compare date DatarowsForOneDay = dt.Select("DailyRecTime= '" + x.ToString() + "'"); So how can I group by date + Hours without care about…

  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='<%#…

  Read the article

• Create trigger for auto incerment id and default unix datetime

  - by user1804985

  Any one help me to create a trigger for auto increment fld_id and Unix datetime. My table field is fld_id(int),fld_date(number),fld_value(varchar2). My insert query is insert into table (fld_value)values('xxx'); insert into table (fld_value)values('yyy'); I need the table record like this …

  Read the article

• Concatenating Date Values - SQL Injection

  - by Kyle Rozendo

  Hi All, We currently receive parameters of values as VARCHAR's, and then build a date from them. I am wanting to confirm that the method would stop the possibility of SQL injection from this statement: select CONVERT(datetime, '2010' + '-' + '02' + '-' + '21' + ' ' + '15:11:38.990') Another…

  Read the article

• MS-Access 2007 Time Online Report

  - by Daniel

  I have the following data in my database: MemberID | DateTime ------------------------------------- 1 | 31/03/2010 3:45:49 PM 2 | 31/03/2010 3:55:29 PM 1 | 31/03/2010 4:45:49 PM Every time a user is authenticated or un-authenticated this log appears in the…

  Read the article

• Quickest way to find the oldest file in a directory using Delphi

  - by Pieter van Wyk

  HI We have a large number of remote computers that capture video onto disk drives. Each camera has it's own unique directory and there can be up to 16 directories on any one disk. I'm trying to locate the oldest video file on the disk but using FindFirst/FindNext to compare the File…

  Read the article

• Date and Time Conversion in Ruby

  - by dkris

  I am currently looking on converting Thu Jun 10 16:17:55 +0530 2010 to 15/06/2010 or 15-06-2010 using Ruby I am getting the dates from the DB as shown below. @tickets = Ticket.find(:all) for ticket in @tickets print ticket.created_at end I have been looking around for…

  Read the article

• MySql difference between two timestamps in days?

  - by user151841

  How can I get the difference between two timestamps in days? Should I be using a datetime column for this?

  Read the article

• How to parse ISO formatted date in python?

  - by Big 40wt Svetlyak

  I need to parse strings like that "2008-09-03T20:56:35.450686Z" into the python's datetime? I have found only strptime in the python 2.5 std lib, but it not so convinient. Which is the best way to do that? Update: It seems, that python-dateutil works very well. I have found that…

  Read the article

• Saving image with Date and Time

  - by Meko

  I am trying to save image captured from web cam with current time.Like 06.06.2010 22:29:52.jpg But compiler does not allow time format 22:20:30 . I searched but I could not find how to write time like 22.29.59 or how can solve this problem ? String photoTime =…

  Read the article

• how to uppercase date and month first letter of ToLongDateString() result in es-mx Culture ?

  - by Oscar Cabrero

  currently i obtain the below result from the following C# line of code when in es-MX Culture Thread.CurrentThread.CurrentCulture = Thread.CurrentThread.CurrentUICulture = new CultureInfo("es-mx"); …

  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…

  Read the article

• 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…

  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:…

  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…

  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…

  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…

  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

• 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…

  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…

  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")…

  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…

  Read the article

< Previous Page | 18 19 20 21 22 23 24 25 26 27 28 29  | Next Page >