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 12,250 times on 713 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 1 day, 13 hours ago (2009-11-09 06:41:00)
by Martin
Hi, I am wondering how to compare 2 datetime values so that milliseconds are taken into account. as an example I have the following script. it appears that if I compare two datetime variables then milliseconds are not taken into account, however if I compare two datatime2 variables then milliseconds are taken into account. I have put together the script below to demonstate the problem. ...
Started 1 day, 23 hours ago (2009-11-08 19:54:00)
by amalatsliit
hi i'm having problem with linq query... this is what i have var query = from venue in db.Venues select venue; query = query.Where(q => ; SqlMethods.DateDiffDay(q.ExpiresDate, DateTime.Now) == 7); query = query.Where(q => ; q.IsDisplay).OrderByDescending(q => ; q.ExpiresDate); what i want is to populate venues which are expired 7 days from...
Started 3 days, 13 hours ago (2009-11-07 06:09:00)
by Mr.Kode
hello all i want to know how to get DateTime array through DataReader and set it as bolded Dates on MonthCalender i have the following code .. SqlCommand GetDates = new SqlCommand(); GetDates.Connection = new SqlConnection(ConS); GetDates.CommandType = CommandType.Text; GetDates.CommandText = "select Reserve_Date from reservations where Done = 0";...
Started 4 days, 15 hours ago (2009-11-06 04:23:00)
by Chris Garvey
Hi All, I have a string in the following format which I am trying to convert to SQL Server datetime. yyyymmdd24miss Eg. 20091102165659 I have tried casting using the following statement: Select cast (20091102165659 as datetime) Error received - Arithmetic overflow error converting expression to data type datetime. The destination field in SQL Server is set to standard datetime. Any ...
Started 5 days, 4 hours ago (2009-11-05 15:28:00)
by krpurcel
I have a login and a logout field where the data is listed in seconds: LOGIN: 1,257,328,840 LOGOUT: 1,257,340,039. I need to convert these to DATETIME formats so we can check schedule adherence. I have tried DateTime({login]) an DateTimeValue({login}). Both generate an error message of "Dates must be between year 1 and year 9999". Am I using the wrong function? Do I need to manipulate the ...
Started 5 days, 12 hours ago (2009-11-05 07:27:00)
by pxh12
Hi, I'm trying to write a trigger that will create a record in a table when a value is changed. When I fire the trigger, I get this error: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value The problem lies in the passing of a date to a stored procedure, but it only occurs when I call the SP from the trigger. If I replicate the process in a ...
Started 6 days, 3 hours ago (2009-11-04 16:15:00)
by jashimu
Hi all, I am trying to use SQLite database for my App. It seems like I can insert datetime into datetime column. Does anyone know how to do this. thanks in advance.
Started 1 week ago (2009-11-02 23:18:00)
by FKearney
Is it possible in Reporting Services 2008 to convert a decimal to a datetime format of HH:MM? I am pulling data from SSAS and in order to get the value of time into the cube as a measure I needed to convert the time to a float and then pass it into the cube. SSAS knows how to conert it by specifiying the format as hh:mm. Unfortunately SSRS seems it is ignoring the format and using the decimal ...
Started 1 week, 1 day ago (2009-11-02 18:30:00)
by Aaron Jarboe
I am running reports in SSRS 2005 from VS TFS 2005 from an OLAP cube. I have a table with my data, and a filter that is attempting to do the following: Filter: =Fields!Date.Value > =#12/04/2009# Apparently "Fields!Date.Value" is of type String and not DateTime, because I get this error: "Cannot compare data of types System.String and System.DateTime. Please check the data type ...
Started 6 days, 16 hours ago (2009-11-04 03:07:00)
by anirai
datetime calendar hi..i want to add my country's calendar in vb.net program..instead of english calendar provided by datetimepicker i want to add nepali calendar...but no idea..how can i do that? thanks
Started 6 days, 3 hours ago (2009-11-04 16:03:00)
by Deepayan Nandi
I'm working on a page that has a regular calendar control, i bind "selectedDays" to a database and show these days with an offset background color. This tells the user that a record exists on that day. My next step is for the user to then click that date and in a RadDataGrid show all the records for that day. At this time when i click a highlighted date that i know has a record, it will only ...
Started 6 days, 14 hours ago (2009-11-04 05:14:00)
by ecgc
Okay so say I have to insert the current date and time into the mysql database, I want it to be formatted differently than I did in my below code: Code: PHP Code: $sql = "INSERT INTO $table_name (dateuploaded) VALUES (NOW() )" ; //stores records in database So I tired date format and every way I could think of and it still inserted the generic...
I need to debug a store proc that isn't working correctly - all of a sudden. I haven't used the sql server 2000 enterprise debugger in years. I vaguely remember that you have to use some unintuitive notation to specify parameters. My request is if someone could tell me how to enter a date param and a string param? @myDate = '10/31/09' @userID = 'xyz' I tried with and without the quotes -...
Started 1 week ago (2009-11-03 02:00:00)
by KevinB
Quote: Stanley Works to Acquire Black & Decker for $4.5 Billion BLACK AND DECKER, EARNINGS, FORECAST CNBC.com | 02 Nov 2009 | 05:53 PM ET function UpdateTimeStamp(pdt) { var n = document.getElementById("udtD"); if(pdt != '' && n && window.DateTime) { var dt = new DateTime(); pdt = dt.T2D(pdt); if(dt.GetTZ(pdt)) {n.innerHTML = dt...
Started 1 day, 21 hours ago (2009-11-08 22:04:00)
by JREAM
I have this number: 23.883333333333 I have already went from calculating a DATETIME to the current DATETIME, so I calculated the difference. I would like to know how many hours and minutes that is. I know its 23 hours and maybe like 50 minutes, because there are 60 minutes in an hour. So I was thinking I should number_format it. But how do I make so that it shows the minutes in...
Started 6 days, 16 hours ago (2009-11-04 03:33:00)
by shajju
Hi guys I need to add a constraint to a table. This table already has a couple of constraints specified by which were specified using: Code: ALTER TABLE USLM ADD ( CONSTRAINT USLM_PK PRIMARY KEY (DATETIME, MSC) USING INDEX LOCAL); I'd like to add another column called LOC as a PK to the constraints. Can I simply say: And now I need to add another column as ...
Started 2 days, 16 hours ago (2009-11-08 03:10:00)
by shajju
Hi guys I have the following query which I'm trying to get to work: Code: select A.BSC, A.CELL, MIN(A.DATETIME) DATETIME, SUM(NVL(ALLOC_S,0)) AS ALLOC_S, ROUND(DIV(NVL(ALLOC_S, 0),(NVL(ALLOC_S, 0) + NVL(ALLOC_S_F, 0))), 2) * ROUND(DIV(NVL(ALLOC_T, 0),(NVL(ALLOC_T, 0) + NVL(ALLOC_T_F, 0))), 2)*(1 - ROUND(DIV((NVL(RF_L, 0)),(NVL(ALLOC_S, ...
Started 3 days, 3 hours ago (2009-11-07 15:49:00)
by nmartin
Hey everyone.. I am creating a small little bug tracking application to use as an example. So I have an issues table: Code: [dbo].[Issues]( [Title] [varchar](255), [Description] [varchar](max), [LastUpdated] [datetime] NOT NULL, [UserId] [uniqueidentifier] NOT NULL, [SeverityId] [int] NOT NULL, [StatusId] [int] NOT NULL, [ID] [int] IDENTITY(1,1) NOT NULL, ...
