I have a datetime column where I store the amount of time a person workded on a project, so it might be 2011-02-16 05:00:00.000 in the column, this being 5 hours. I need to get a sum of the hours in my sproc I tried
[Code]....
But it tells me I cannot sum on datetime.
convert below datetime value which is as varchar datatype to another datetimeformat as varcharchar datatype
2010-05-19T13:05:08.6Z
I am confuse in understanding date storing in sql server and retrieving it in C# and converting date formats. guide me on the following basics:
1. In SQL Server datashould be stored as datetime or as string ?
2. To get date in different format (in SQL Server) why we convert it in string, is there no way that date can be obtained as date but in different formats ?
3. For getting date in some particular format is it better to convert date in format from SQL Server or it should be converted in C# ?
4. On C# end what should data type to hold date ?
5. In C# what should data type (string or date) if date is coming from database ?
6. In C# Cant we format date when its data type is date ?
Passing a null or nothing value to a datatime datatype database field (Access)
I've been all over the internet looking at this and I have tried dozens of methods without success.
I've read a few forums where, some say you can not assign a null value or a nothing value to a datetime datatype field. Then I see others where they say...'I got it to work'.
If this is true (that you can not pass a null value), how come I can create a record in the Access table and not assign a value to this date field? (The field is defined as not required).
Yet, once a value is in the field, I can not update that field back to a null or a nothing value.
So I'm hoping someone has the definitive answer to this.
I am using VB.Net Vs 2003 and updating an Access data base.
I have an update statement (see below) that uses parameters for updating.
what will work, so that I can put back the null or nothing value?
Or if it really can not be done, I guess I'll have to take that as truth.
[Code]....
I'm passing a model to a view, and the model contains this attribute:
[Required(ErrorMessage = "Please enter a start date")]
[DataType(DataType.DateTime)]
[DisplayName("Start Date")]
public DateTime StartDate { get; set; }
And I have this in my view:
<%: Html.TextBoxFor(m => m.StartDate) %>
When I load the page, the textbox is populated with a date: 1/1/0001 12:00:00 AM
Is there a way to not have this happen, maybe by using metadata?
is a way of proofing a stored procedure in terms of the datetime localisation. For example, in the C# we may use the web.config or machine.config to set the application's localised date settings:
<pre>globalization uiCulture="en" culture="en-GB"></pre>
This helps when we do a date comparison in a static class of ours to return a certain rating factor. Is there an equivalent way of us checking whether or not the date we pass into the stored procedure is in e.g. UK format and will be compared against our dates in the UK format too? We have 2 datetime columns, DateEffectiveFrom and DateEffectiveTo in our table and we use those dates to compare with the date passed in to return the relevant data.
I'm loading data from my database into a DataTable, and one of the columns is a date field.
[Code]....
I'd like to format that column so that instead of containing a full date, it will be formatted like "MM/DD/YYYY".
I've tried looping through each row in the table and changing the cell for that column, but I get an error saying that the string isn't a valid DateTime object.
I tried changing the column DateType to a string, but I get an error saying I can't change the DateType after the table is filled.
How can I do this? This seems like such a simple thing, but I'm having so much trouble with it.
in sql 2005 table fields named fromdate and todate which is having the values like as follows
2010-10-23 05:30:20.000
2010-10-24 16:43:10.000
i want to update this date time values like as follows
2010-10-23 00:00:00.000
2010-10-24 11:59:59.000
ie.initial time of the day and the max time of the day
lot of records are thre in fromdate and todate colum .need to update these values with a single query,without chainging the date.Need to change only the time portion
I am working on windows mobile and using webservice to store data on server. When I save data from mobile to server Datetime is not stored correctly on server as it should be. Datetime has been changed to Server Datetime which is wrong. I want that it should save that date which i have passed from Windows Mobile.
View 1 RepliesI'm having a little issue, currently my code, first it saves to DB then send an email in both codes it saves and send the current date and time. I use the following function to get the current date Now() . The problem is when it saves to DB, it saves the current time and date using the timezone of DB server location and the email send the date and time and appear in my wanted timezone (easter time zone). I was wondering if it's possible to make the also save to DB with the correct time zone without using any javascript.
View 2 RepliesHow show local time in datagridview collumn DateTime from database with universal datetime
View 2 RepliesI could probably figure this out if I tried to, but I have been working so long on code, I'm a little fried
I have a stored procedure, and I want to execute another stored procedure during a time period of lets say 1/1/2011 to 12/31/2011
How Would I accomplish this?
In my stored procedure there are 8 queries for 8 tables.Each query has joins and sub queries. I am passing parameters & stored procedure name from front end(designed in asp.net 3.5) can we execute that 8 queries at the same time i.e. parallel execution so that I can minimize stored procedure execution time?
View 6 RepliesYou'd think since MS SQl Server 2008 and asp.net are both Microsoft products, asp.net would support the new "time" datatype but anyway.
This is one data field in gridview called "timesort"
<asp:templatefield HeaderText="timesort" SortExpression="timesort">
<EditItemTemplate>
[code]...
Our business case requires that a Start Time and End Time must be defined for each Organization involved in the business model. For example; some organizations have their working hours from 8:00AM to 5:00PM and others from 9:00 to 6:00PM. While creating a new Event on our calendar these should be queried from the database (StartTime and EndTime) and setting these as default. My questions are:
1) How should I save these times since DateTime requires a Date in front of it and there's no Time column format on SQL Server (Varchar? Number?). If using one of these types how to I concatenate these to a DateTime variable?
2) If the column should be DateTime, how do I concatenate it to replace the column's Date with Today's date and replace the Time with the time specified for that? Let me be more clear:
Default values saved in the database: StartTime = "2010-01-01 8:00AM" EndTime = "2010-01-01 5:00PM" In my code after querying, my local variables would be populated and replaced by: OrgStartHour = "2010-03-26 8:00AM" and OrgEndHour = "2010-03-26 5:00PM"
[Code]....
The code above works but I have no idea on how to replace/concatenate the "2010-01-01" with today's date while keeping the "8:00 AM" on it. :)
I wanted to know how to prevent more than one user from uploading the report at a time .
This is a Windos based app written in c# . When User A clicks Upload option on one server from the menu to upload the files and at the same time when User B clicks Upload option on different server , User B should be alerted a message saying "User A's uploading is in progress,pls wait" . How to achieve this, with the code..I am thinking this logic should be kept in a stored proc, How do I write that proc?
i am displaying some news from rss feeds in the page. But i am stuck up in the date time conversion. I got th published datetime as pdt formated string. How can i convert to my local time. Coversion from the pdt string tot DateTime is error..
[Code]....
This second line is error and i need the result in the specified format or same format as in the published date but in local time ie IST (India Standard Time)
i am store ms word resume to image(BLOB) data type in sql server 2005. now i want to display this resume in HTML page or in text area. and for that i use
[code]....
I am trying to store a SQL Server datetime into MySQL datetime field, but MySQL stores the date value as all zeros. I use this function to trim the fractional part from the SQL Server datetime, but get the same result when trying to store it in MySQL.
[Code]....
I am trying to get data from mysql database and store in sqlserver database. i am getting the following error
The given value of type MySqlDateTime from the data source cannot be converted to type datetime of the specified target column.
I have one pretty stupid problem - datetime issue. I've made one stored procedure for making jobs
[Code]....
[Code]....
Sometimes I get a datetime with a time sometimes it's just the date. Of course if it's just the date I I want to format with "dd.MM.yyyy" and if it has a time "dd.MM.yyyy HH:mm".. This is in a repeater, so I thought may be it's possible without a simple if statement?
View 3 RepliesIn MSSQL server 2005/2008, we have one column (in a table) declares as "Image" type. What data type in C# so I can grab that value in that column in our class? Can string handle it or byte[]?
View 1 RepliesI have a tabe related to songs which has columns like songID, album, Artist, track etc. I want the data for track to be entered in the format 1/2, 2/2 like this. What shpuld b the datatype of this value? If I'm entering a new data or updating the columns from a web page how can I check the track textbox to enter the correct value? Can I use any validation control? if so how can i use it?
View 6 RepliesI'm using Cute Editor for ASP.NET for the first time, and it's occasionally refusing to insert or update a record. Basically the records are just composed of a bunch of HTML and text. So far I can't detect a pattern to the problem and I'm wondering about my data type.
I tried VARCHAR(MAX), NVARCHAR(MAX), and NTEXT, doesn't seem to fix it.
So what is the best SQL data type for HTML?
And could that be causing CuteEditor to refuse to insert/update records? Or something else?