Search Results

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

Page 7/342 | < Previous Page | 3 4 5 6 7 8 9 10 11 12 13 14  | Next Page >

• Datetime and date-range comparsion

  - by Ockonal

  Hello guys, I have datetime-row in mysql database. I have to check time between now and that date using php. If the range is bigger then 1 month - do somtething. I tried something like this: $dateFromMysql = strtotime($rowData); $currentDate = date("m/d/y g:i A"); And then comparsion by hands. It's ugly.

  Read the article

• How to get the Time value from datetime picker

  - by Ranjana

  how to get the time value in a stored procedure form datepicker value i.e i have a datetime picker value stored into my table as '2010-04-06 09:00:00.000' '2010-04-07 14:30:00.000' i have got the date sepeartely using convert(varchar,Date,3) as Date.. i have got the time seperately using convert(time,Time) but it show the values as 9:00 , 14:30 i need it to show as 9.00 am and 2.30pm instead of 14.30. How to achieve this????????? and help??????

  Read the article

• DateTime c# parsing

  - by Dani

  I try to parse DateTime.TryParse("30-05-2010"), and it throws an exception because it accepts MMddyyyy, and I need ddMMyyyy format. how can I change TryParse format? thanks, Dani

  Read the article

• DateTime Subtract in C#

  - by Ravi

  Hi, I want to Subtract dateTime. Ex: date1 = 13/01/2004 12:20:00 result = Subtract(date1-15); O/P : 13/01/2004 12:05:00 Thanks

  Read the article

• Get day from DateTime using C#

  - by devnet247

  Hi. Silly question. Given a date in a datetime and I know it's tuesday for instance how do i know its tue=2 and mon=1 etc... Thanks

  Read the article

• How to select from datetime in sqlite?

  - by Sein Kraft

  Joined is a datetime data type column in the database and dates are saved as '12/05/2010 15:54:32' This my query: SELECT * FROM users WHERE joined BETWEEN '12/05/2010 00:00:00' AND '12/05/2010 59:59:59' ORDER BY id ASC But it doesn't work. It returns no rows. So how i gan get them?

  Read the article

• Convert SQL server datetime fields to compare date parts only, with indexed lookups

  - by Caveatrob

  I've been doing a convert(varchar,datefield,112) on each date field that I'm using in 'between' queries in SQL server to ensure that I'm only accounting for dates and not missing any based on the time part of datetime fields. Now, I'm hearing that the converts aren't indexable and that there are better methods, in SQL Server 2005, to compare the date part of datetimes in a query to determine if dates fall in a range. What is the optimal, indexable, method of doing something like this: select * from appointments where appointmentDate='08-01-2008' and appointmentDate<'08-15-2008'

  Read the article

• convert string of millisecond into datetime in python

  - by newbie

  I am a newbie in Python. I want to substract interval time from my log file, but the problem is I cannot convert millisecond string of log file into datetime format. For example, I have 15:55:05.12345 and I want to remove 5.12345 seconds from this string, and shwow result of 15.55.00.00000 in Python. How can I do that? Currently, I am using python 2.5. Thank you in advance.

  Read the article

• Whats wrong with DateTime object

  - by Ayaz Alavi

  Hi, Can anyone tell what is wrong with the code. $timezone = "Asia/Karachi"; $date = new DateTime($when_to_send, new DateTimeZone($timezone)); $date = $date->setTimezone(new DateTimeZone('GMT')); $when_to_send = $date->format('Y-m-d H:i:s'); error is: Call to a member function format() on a non-object

  Read the article

• Convert date, datetime to timestamp

  - by Beau Martínez

  How can I produce a timestamp to millisecond accuracy from a date or datetime in Python? There are an overwhelming number of methods and ways of doing this, and I'm wondering which is the most Pythonic way.

  Read the article

• MySQL: What's the best to use, Unix TimeStamp Or DATETIME

  - by Axel

  Hello, Probably many coders want to ask this question. it is What's the adventages of each one of those MySQL time formats. and which one you will prefer to use it in your apps. For me i use Unix timestamp because maybe i find it easy to convert & order records with it, and also because i never tried the DATETIME thing. but anyways i'm ready to change my mind if anyone tells me i'm wrong. Thanks

  Read the article

• DateTime Format Strings?

  - by Phil

  I have the date format string dd-mm-yy. Please can you tell me how to add hours and minutes to the string (i.e 13-03-2010.21.03) .... DateTime.Today.ToString("dd-mm-yy") ?

  Read the article

• C#: Using DateTime.Parse with string

  - by Meko

  Hi all.I am trying to get date format from Day name and time like "Monday" and second string "08:15" and it must like 10:05:2010 08:15 and then I will make subtracting from date of today. DateTime.Parse("08:15") it works but it outputs todays date. I want to get date of day name. I also usedDateTime.Parse("08:15").AddDays(1)it gaves me next days date.Here I want to get date of next Monday with and "08:15" time.

  Read the article

• How to convert string into datetime

  - by jstawski

  Hello fellow stackoverflowers, quick question. I'm using C# 3.5 and I have a date that comes in as string in the following format: Tue Jan 20 20:47:43 GMT 2009 First question, what is the name of that format? Second question, what's the easiest and clearest way to convert this string into a datetime? I would love to be able to use a .net API/Helper method if possible. Thanks a bunch...

  Read the article

• Store more than 24 hours in a DateTime

  - by Rob

  I work in a bizarre and irrational industry where we need to be able to represent the time of day as 06:00:00 to 30:00:00 instead of 0:00:00 to 24:00:00. Is there any way to do this using the DateTime type? If I try to construct a date time with an hour value greater than 24 it throws an exception.

  Read the article

• Mysql - datetime and date-range comparsion

  - by Ockonal

  Hello guys, I have datetime-row in mysql database. I have to check time between now and that date using php. If the range is bigger then 1 month - do somtething. I tried something like this: $dateFromMysql = strtotime($rowData); $currentDate = date("m/d/y g:i A"); And then comparsion by hands. It's ugly.

  Read the article

• C# DateTime to "YYYYMMDDHHMMSS" format

  - by SARAVAN

  Hi, I want to convert a C# DateTime to "YYYYMMDDHHMMSS" format. But I don't find a built in method to get this format? Any comments?

  Read the article

• Convert datetime field in sql server 2005....

  - by Pandiya Chendur

  I have a datetime field which has a value like this 5/11/2010 12:04:20 PM .... I am converting this field convert(varchar, dbo.Clients.CreatedDate,103) as CreatedDate and i get the result as 11/5/2010..... But how to get 11/5/2010 12:04 PM.....

  Read the article

• Needs help regarding print in asp.net (need to remove datetime from printpage)

  - by Rajesh Rolen- DotNet Developer

  i am using below code to print my content of webpage in asp.net using javascript window.print(document.getElementById('dvPrint')); when i do print, it automatically adds date time on page.. (i think because of page setup) in firefox. please tell me how can i remove this setting. i mean i dont want datetime to be printed automatically on my print page (even if its set in pagesetup).

  Read the article

• C# DateTime, is this method regional setting safe?

  - by JL

  I am using the following method to serialize a date as a string private const string DateFormatString = "dd.MM.yyyy HH:mm:ss"; string LastsuccessfuldownloadDateTime = DateTime.Now.AddDays(-91).ToString(DateFormatString); Is this the safest way to ensure that the string always gets serialized in this format?

  Read the article

• SQL server datetime column filter on certain date or range of dates

  - by MicMit

  There is an example for today here http://stackoverflow.com/questions/2583228/get-row-where-datetime-column-today-sql-server-noob I am primarily interested in 2008 only. For today it looked like SELECT (list of fields) FROM dbo.YourTable WHERE dateValue BETWEEN CAST(GETDATE() AS DATE) AND DATEADD(DAY, 1, CAST(GETDATE() AS DATE)) What literal value of date(s) or functions ( I need a format ) should I place there to make it work independent of local settings.

  Read the article

• Java - Converting a datetime into gregorian calender time(date)

  - by yogsma

  I am using google data api which gives date in datetime format. I want to convert in Gregorian calendar date format. Does anyone know any methods for doing this?

  Read the article

• MySQL: How to check if a string is a valid DATE, TIME or DATETIME

  - by Svish

  When I try to put a value into a DATE field which is invalid, MySQL seems to use 0000-00-00 instead. Is there a way I can do this "check" without updating a DATE field? And to do it from for example PHP? Like, is there a way I can query the MySQL server and ask "Hey, is this DATE, TIME or DATETIME valid to you?" Or is there maybe an even better way of doing it?

  Read the article

• Change DateTime in debugger

  - by user72185

  What the.... How do I change the value of a DateTime in the debugger? I can change it, but I get an error when leaving the edit field; it cannot parse it. Edit: VS 2008, C#

  Read the article

• Convert DateTime.Now.Month; as string value

  - by Ranjana

  int month=DateTime.Now.Month; It gives output as = 04 But how do I get the month as string 'April' from code behind?

  Read the article

< Previous Page | 3 4 5 6 7 8 9 10 11 12 13 14  | Next Page >