Adding time for past dates dates or correcting a time entry

Hi all,

We are using Bugzilla to record time spent on bugs. Is there a way for
a person to add time on a previous date?

Or is there a way to correct an entry?

I can access the DB by an ODBC connector, but I'm reluctant to change
the date in bugs_activity table.


7/29/2011 8:58:11 PM 10182 articles. 0 followers. Post Follow

1 Replies

Similar Articles

[PageSpeed] 20

On Jul 29, 3:58=A0pm, Sanjay Jain <> wrote:
> Hi all,
> We are using Bugzilla to record time spent on bugs. Is there a way for
> a person to add time on a previous date?
> Or is there a way to correct an entry?
> I can access the DB by an ODBC connector, but I'm reluctant to change
> the date in bugs_activity table.
> Thanks
> Sanjay

When I miss entering time on a bug, my process involves adding the
time and then editing the comment/details in the database. I edit the
corresponding row in bugs_activity, updating the bug_when column to
the correct time & date. Next, I edit the corresponding row in
longdescs and update the bug_when column there, too.

My process is very manual, and it's not a production environment (so I
can take shortcuts). But that's just an idea of what I do.
8/2/2011 4:15:04 PM

Similar Artilces:

date/time or date and time
I am setting up an SQL database and I will need to get differences in dates. For example I have a start date, start time, completion date and completion time and I want to get the difference between the start and completion. Would it be better to have one field with both date and time in it, or better to have a date field and a time field? Even though I have already started setting up the tables with seperate fields for date and time I am now leaning toward one field with date/time in it. (Only because that is the way I had to do it when setting up an Excel spreadsheet for a similar ta...

java date time and utc date time
hi i have a client written in delphi the backend is written in java (webservice) when fetching a date field from the db, through java to delphi (TXSDateTime class), for some reason the date changes. in the db: 30/07/2009 00:00:00 in delphi: xsdatetime.asdatetime = 29/07/2009 23:00:00 (1 hour before) in delphi xsdatetime.asutcdatetime = 29/07/2009 21:00:00 (3 hours before) i guess it's a matter of timezones but all we want is simply to fetch the same date as it appears in the DB what are we missing? thanks amos szust wrote: > hi > > i have a client written in d...

Adding time intervals to date/time
Hi, Wondering if someone who has knowledge of c# and can help me out here. I have a meeting booking system, that automatically checks an employee's calendar in a database and returns the next available time to the web page.  The way i am doing this is adding 30 mins to the initial time provided until a free time is found. However, i want this to stop by 5.30 (end of working day)_ and then continue looking from 9am the next morning, and i have NO idea how to do it.  My code at the moment for this looks like: while (Reader.Read()) { //ADDING 30 mins TO THE PROPOSED MEE...

just Time or date portion of a date/time field
Good Day, From a DateTime data column how do I get just a Time portin or just a date portion of data to be displayed. i.e from 11/6/2003 10:03:20 AM I need to display date and time seperately in my data display page. Thanks Regards, In code you could use Dim dt as System.Date Dim day, month, year as integer day = dt.Day month= dt.Month year = dt.Year This also works with DateTime In SQL you could use DATEPART(<datepart>,<datetime>) where <datepart> is the abbreviations mentioned in post 385301 and <datetime> is a...

Compare file modified date time to system date time
I have an client application that uploads a zip file to a server. Once the server application sees the file, it processes the file. The process starts before the zip file is completely downloaded to the server. I want to delay the process until the file is completely downloaded. I am trying to compare the zip file modified date time with the system date time. If the zip file modified date time is 5 seconds older than the system date time then I know the zip file downloaded. At this point I will continue to process the zip file. I am not sure how I can compare the two date time. The DateTime....

Convert MySql Date/Time to Date/Time
I am pretty new to ASP.Net and to MySql. I am receive the following error message when I try to retrieve a date field: Unable to convert MySql date/time to System.DateTime The message points to the following code: Response.Write(dtrReader("fldDate")) What do I need to do so that I can read this date into my program.  It appears they two systems store dates differently, but I do not know enough about either to know where to begin. Please help Thanks Is your issue like this one? Also try setting the "Allow Zero Datetime" = True in the ConnectionString.

just Time or date portion of date/time field: SOMEBODY PLS
Good Day, From a DateTime data column how do I get just a Time portin or just a date portion of data to be displayed. i.e from 11/6/2003 10:03:20 AM I need to display date and time seperately in my data display page. Thanks Regards, When you pull in a SQL datetime column value into your .NET code, it is usually cast to a .NET DateTime type... something like this: System.DateTime TheDateAndTime = (System.DateTime)someDataReader["MySQLDateColumn"] Then you can use a variety of .NET methods included in the DateTime class to convert to a strin...

Date entered...add time value to make date/time field
Windows XP Professional InfoMaker v 9.0.2 Build 7509 Our database contains a date/time stamp for when a specific activity happens to each shipment. I would like the users to be able to simply enter a date for a specific work day. I need to get a list of shipments where the time of one activity occurred on the entered date prior to 9:20. How can I create a computed field that will basically concatenate/amend the entered date with 9:20 that will later be used for criteria in returning rows? Thanks in advance for any help you can provide! Rita Palazzi Senior Engineer /...

Server Date & Time vs. Local Date & Time
I have the following code (which some members assisted with) and it works great locally... It takes the date and time and formats just the way I want:  e.g.:  10/28/2008 13:58:44 becomes 102820080158 (which is what I want) But, when I upload the app to our server the date pulled is:           10/28/2008 1:59:37 PM As a result the date skips the formatting and does not work, so how can I code this so the date/time will be the same whether its local or on a server, and I have adjusted the regional settings to match - and same issue...

Removing Time from date time
We would like to form a recordset that would have the datetime column be just the date. We have students visiting our web several times a day and each of these are counted as distinct dates. We would like just the total number of days that they used the web not the total number of times they accessed the web. Thanks Jim You can use date function on datetime column, or use cast. eg: select datetime_col, date(datetime_col), cast(datetime_col as date) from some_table Hope this helps, Goran jmwarren wrote in message <>... >We would li...

Dates, Dates, Dates!
Hello all... I am in the process of building an appointment system, and I am trying to see if I can get some pointers on which way to go on this. The first version of this appointment system was very lo-tech, and it stored all of the possible dates/times in the database. Once a user booked an appointment, their information was logged to that date/time, and then that date/time would no longer show in the list of possible openings. This was great for a temporary fix, but with having to pre-populate all of the dates/times, the system would eventually have to be updated to continue on pa...

Date raw date time
I have a value in a string array that is {3/15/1976} When I do a tostring with a short date it changes that to 15/03/1976 Is there a way I can get just the raw text out of the string? Without it giving it to me as a date? Thanks Hi latrotter2, If you have a DateTime object and want to the string value to have a certain format, you must pass the format to the .ToString() Methos. Example: [Visual Basic] Dim tempDateString As String = DateTime.Today.ToString("M/d/yyyy") Response.Write(tempDateString) [C#] string tempDateString = DateTime.Today.ToStr...

Convert Date/Time to Date
Hi I'm using .NET 2.0 framework with a Postgres DB. I'm getting date values from the table 'creationdate' and I need to compare it with other date value (given by me). The thing is that tha date returned from the DB comes like this '27-03-2006 0:00:00' and the date value that I use to campare comes like this '27-03-2006'. I want to know how to convert the returned date value from the DB to date only...?! I tried using the following: SELECT CONVERT(char(10),creationdate,101) AS date FROM WHERE date = "myDate"; but it gives me an error: syntax error at or near "," at c...

Hello, If the field is defined as a DATE and you do: select datefield+1 from mytable Does the ODBC API (actually ASA 9.02 backend) return a field that is DATETIME or a DATE field? It is messing up my compiled application and seems to be coming back as DATETIME. Thank you. -Robert You are correct, the value is being returned as a TIMESTAMP. You can verify this through using the EXPRTYPE() builtin function, as in select exprtype('select datefield+1 from mytable', 1) from dummy which will return TIMESTAMP. Exprtype is documented in the help. You alm...

Web resources about - Adding time for past dates dates or correcting a time entry -

Facebook Correcting Bug That Collected Phone Numbers Of Android App Users
Facebook is taking steps to address a bug discovered by Symantec in which its Android application collected users’ phone numbers. continued… ...

George Takei - OMG, I need a valium after correcting this.... - Facebook
OMG, I need a valium after correcting this. Sent it to the Newspaper Manager and Editors as well. Can't believe it had ever been edited at all: ...

Correcting an NBN Co disconnect
Behind the expected red numbers NBN Co revealed some encouraging trends, albeit off a low base. And Bill Morrow is moving decisively to clear ...

Correcting a cultural amnesia
Doyen of American journalism Lewis Lapham has a new magazine reminding America of its history. - The Age Online

Correcting history – how the modern game of AFL was invented
The Naked City column is devoted to shining a light on the dark world of crime and on this bright Grand Final day nothing will change. It is ...

Vodafone is correcting its problems: Bill Morrow - Inside Business - ABC
ALAN KOHLER, PRESENTER: While the media is struggling with challenges being thrown up by new technologies, over in telecommunications the whole ...

Liberal Critiques Of Challenges To Obamacare: 2 Errors Worth Correcting
What do liberal critics of Obamacare challengers get wrong?

Correcting Apple's A9 SoC L3 Cache Size: A 4MB Victim Cache
Along with today’s analysis of Chipworks’ A9X die shot , I’m also going to use this time to revisit Apple’s A9 SoC. Based on some new information ...

Correcting Franzen
Jonathan Franzen’s recent interview with Colombian author Juan Gabriel Vásquez aggravates Chad W. Post’s anti-Franzen bias. He cites the following ...

Correcting Grammar and Spelling Is Regarded as Racist at UCLA
Crazy times, sad times. All You Need to Know About the ‘Learning Styles’ Myth, in Two Minutes The average college freshman reads at 7th grade ...

Resources last updated: 1/20/2016 1:30:04 AM