When I select some data rows from mssql2005 database and bind them to datagrid, dates selected from db are invalid. For example in db I have date in form: 2009-05-10 00:00:00.000 but when it is displayed in data grid it looks like this: 5/9/2009 10:00:00 PM So it shows 2 hours earlier then saved in db. 05 - it is month :-) What a...
I am implementing a Fuzzy Date control in C# for a winforms application. The Fuzzy Date should be able to take fuzzy values like Last June 2 Hours ago 2 Months ago Last week Yesterday Last year and the like Are there any sample implementations of "Fuzzy" Date Time Pickers? Any ideas to implement such a control would be appreciat...
I have three columns: a date column, a integer column, and a varchar column like this: +------------+------+---------+ | date |value | unit | +------------+------+---------+ | 2009-01-01 | 2 | DAY | | 2009-02-01 | 3 | MONTH | +------------+------+---------+ I want to use the values of the integer and the varchar...
I have to get data from Oracle Table in which I have one datefield called lastupdatedDate and I want to get only that rows back in which lastupdatedDate is in last 10 mins of sysdate for example if in my table I have lastupdateDate as 05/20/09 4:20:44 then I want this row back in my result until from if I run the query in between 0...
Hi I have a table in SQL Server 2005 which has a date time field. I want to save the date time value in mm/dd/yyyy hh:mm:ss format, but I guess SQL Server allows date time in yyyy-mm-dd HH:mm:ss.ll format. I can save date time value in mm/dd/yyyy hh:mm:ss format as a varchar, but that defeats my intention of sorting the table on that d...
To make time like "2009-05-02 00:00:00" to "2009-05-02" I know I can achieve this by regular expression, but would be better if there is a built-in function that can do this. ...
In our code, we have a 16-byte packed struct that we call "ISOTIME": typedef struct isotime { struct { uint16_t iso_zone : 12; // corresponding time zone uint16_t iso_type : 4; // type of iso date } iso_fmt; int16_t iso_year; // year uint8_t iso_month; // month uint8_t iso_day; // day uint8_t iso...
Is there a function which exists in both C# and (unmanaged) C++ which returns a synchronized number (such as float or int)? For example is there something which brings the exact system time to at least the second which would return the exact same result on both C++ and C# is called in the exact same time? Just wondering really =) ...
Hi!! How can I convert an int 90, for example, to DateTime 1:30 in C# 3.0? Thanks!! ...
Is there a API method in JodaTime to see whether a DateTime is within [start, end], i.e. the boundary is included? Only thing I found was new Interval(start, end).contains(dateTime) but this seems to give false if dateTime equals end. ...
Is there a way to extract timezone information directly from an oracle.sql.TIMESTAMPTZ object (selected from a TIMESTAMP WITH TIME ZONE column)? Ideally, I'd like to be able to pull the time zone information directly out of the object without jumping through potentially expensive or fragile hoops (like converting things into strings and...
I am using VB6 for my application. I've populated Excel with the RecordSet obtained from a SQL query. One column called Time_period has values like "2/31/2006" "12/29/2000" etc. I need to pass these inputs to another SQL query for processing. I am little confused with the formats, as Oracle accepts inputs of type "23-Jul-2009", "02-...
I'm looking to see if there is an official enumeration for months in the .net framework. It seems possible to me that there is one, because of how common the use of month is, and because there are other such enumerations in the .net framework. For instance, there is an enumeration for the days in the week, System.DayOfWeek, which inclu...
Hello .. I want increase time to current time for example, I have the time of the problem and the expected time to complete them How can I add? (DateTime.Now.ToShortDateString() +.......) ...
In my c# app, I pass a string variable that is of format yyyymmdd-yyyymmdd that represents a from and to date. I want to get the start and end times for these dates respectively. Currently I have the below code but was wondering if there was more of an elegant solution? So for pdr = 20090521-20090523 would get "20090521 00:00:00" and "2...
I've got a timestamp as a string like: Thu, 21 May 09 19:10:09 -0700 and I'd like to convert it to a relative time stamp like '20 minutes ago' or '3 days ago'. What's the best way to do this using Objective-C for the iPhone? ...
I have a set of positive numbers. Given a number not in the set, I want to find the next smallest and next largest numbers that are in the set. The only way I can think to do it now is to find the next smallest by decreasing by 1 until I find a number in the set, and then do the same for finding the next largest. Motivation: I have a bu...
I'm trying to display a datetime from my MySQL database as an iso 8601 formated string with PHP but it's coming out wrong. 17 Oct 2008 is coming out as: 1969-12-31T18:33:28-06:00 which is clearly not correct (the year should be 2008 not 1969) This is the code I'm using: <?= date("c", $post[3]) ?> $post[3] is the datetime (CURRENT_TI...
I am using a Repository pattern with filters in my MVC application. The project displays a list of transactions where I can specify a date period to get a subset of transactions, or specify a specific date to get transactions for that date (including year, year/month, and year/month/day views). I also have functionality for paging getti...
As title, how can I set a table's column to have the default value the current year and month, in format 'YYYYMM', like 200905 for today? ...