Topic profile page for DateTime.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: DateTime.
Topic "Datetime" was discussed 15,316 times on 771 sites in last 3 months
@ bellware @ jschementi works well for the most part,... @ bellware @ jschementi works well for the most part, use it daily, but there are some strangeness sometimes eg. trying to stub DateTime.now 3:54 PM Aug 10th from TweetDeck
Started 2 days, 11 hours ago (2009-11-28 07:43:00)
by teena_pansare
Hey, I am a beginner in the technology of the coding and need some help regarding the codes. I am developing a program of .Net and wanted to compare two DateTime Object . But i have no idea of doing the same. I tried lots of technique to do so but could not succeeded so finally i came here to ask the same. So please help me to resolve the issue of DateTime Object. Any help may...
Started 3 days, 4 hours ago (2009-11-27 14:43:00)
by kurtsimons
DateTime... how do i set the date how can i set the DateTime object to the date i want? dim DT as DateTime DT.Date="2/2/2004 12:00:05" __________________ Kurt Simons [I know I'm a hack but my clients don't!]
Started 4 days, 8 hours ago (2009-11-26 10:09:00)
by sameer27
I've been trying to get asp.net to filter according to the start date and end date for user based on the record from create date on the sql server but it doesn't seem to work out. I keep getting error's like datetime is not recognize, is not a string. I'm using VWD 08. I do not want to change the codes in the jscript file nor do i want to change anything in the back end. Is it ...
Started 4 days, 12 hours ago (2009-11-26 06:36:00)
by epb1
Hi guys, I use LINQ to SQL and Dynamic Data controls. I have created a partial class that represents a table in my database. The table has three datetime fields (among some other fields that are not relevant in this matter): MyDate, MyDateSet and LastModified. MyDate and MyDateSet are nullable while LastModified is not nullable. MyDate is to be updated by the user while MyDateSet and ...
Started 4 days, 19 hours ago (2009-11-25 23:43:00)
by lathangi.ch
> Hi, I am a newbee to this forum but not to sql server .This is the first time i am having a problem in comparing two datetime values.I am trying to develop an ageing report for my data.Here is the sample data.. Name Amt 2yr -------------------------------------------------- ------------- John $25.50 10.0 - 15.50 - - - Smith $17.25...
Started 1 week, 1 day ago (2009-11-21 18:56:00)
by JREAM
If you fetch a MySQL DATETIME that's not set, Output: 0000-00-00 00:00:00 if (empty($date)) { echo 1; } if (!isset($date)) { echo 2; } How do I check if the Date isn't a real date?
Started 6 days, 2 hours ago (2009-11-24 16:09:00)
by iLes
I have a column in my table that is a DateTime column. I have a Session that is written from the previous page that writes (system.datetime.now) to before it transfers to the next page. On the next page I have a SQL statement that will retrieve data from the table, with a WHERE Clause Where the Date(DateTime) column in the table = Session("date") from the previous page. How ever this ...
Started 4 days, 22 hours ago (2009-11-25 20:27:00)
by Dopey Coder
Article ID: 842545 - Last Review: May 18, 2007 - Revision: 1.5 Remoted DateTime values in a DataSet object are converted to the equivalent local time of a remote computer that is in a different time zone. The work around works great except for the AZ timezone when it is not daylight savings time. A date sent to AZ is being adjusted 2 hours by the web service but the actual time difference is ...
Started 1 week, 1 day ago (2009-11-22 11:15:00)
by Gregory Kaidanov
We have installed new computers . The culture has been set to he-IL , as it should in regional settings and in asp.net iis tab in global edit configuration. When I've created a new console in c# and in main put in the line DateTime date = DateTime.Now ; My output was - "22/11/2009 12:54:42" as it should by the format "dd/mm/yyyy ..." but when I've created the same project in vb.net ...
Started 1 week ago (2009-11-23 12:01:00)
by Kumar03
Hi All, I'm trying to convert datetime column to nvarchar(50), below is my example:- Create Table #temp (id varchar(10), dt datetime) Insert Into #temp Values ('234', '2009-11-23 06:09:28:680') Insert Into #temp Values ('234', '2009-11-13 08:09:28:680') Insert Into #temp Values ('234', '2009-04-03 10:09:28:680') Select *, convert(nvarchar, dt) as newdt From #temp Drop Table #temp ...
Started 3 days, 11 hours ago (2009-11-27 07:44:00)
by iand109
Hi, I have a SQL 2005 DB and using ASP VB. I have a form that a user selects 'Month' and 'year' to run a 6-month forecast report. I'm trying to make the results page load up the next 6 months'-worth of month names in a table. So if a user selects 'June', the results page will load up 'June', 'July' etc. I'm using Dreamweaver and have tested the result set, which works OK, but ...
Started 1 week, 1 day ago (2009-11-22 13:29:00)
by tuanbs
I select a table in database into dataset, in this table include filed date(smalldatetime). Then I set this dataset to gridView. And column Date of GridView always display MM/dd/yyyy hh:mm:ss like 11/16/2009 4:13:00 PM. How to display only MM/dd/yyyy.
Started 4 days, 10 hours ago (2009-11-26 08:36:00)
by kerry
timestamp in odbc Hi I'm using Visual Basic 6.5 through Excel 2007. Using the macro recorder I have got code to extract records from a database using odbc. The code has a fixed datetime string, however I want the user to be able to specify a single date so records created on that date are returned. Each time I try putting a ...
Started 4 days, 17 hours ago (2009-11-26 01:07:00)
by pragal
Dear, Im using BO 5.1.7, Database as SQL Server2000. How to convert the date, In sql server im using below query and populate the data. cast(cast(Install_date as varchar(12)) as datetime) =cast(cast(getdate()-1 as varchar(12)) as datetime) Please let me know how to do the above query in Desinger.
