i have a table with startdate and enddate, how my sql should be if ii need to get the record where enddate-startdate > 30min??
startdate format: 2009-05-22 13:06:34.177
enddate format: 2009-05-22 15:06:02.185
I have a timestamp column which I require to change the time back by 1 hour for all records.
View 5 RepliesI 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]....
if i have field datetime = 2010-09-08 11:31:59.123
2010-09-08 17:42:08.737 2010-09-09 9:42:08.737
how can i group by only date? Eg: 2010-09-08 = 2 record 2010-09-09 = 10 record currently when i use group by datetime.. because of the time differece, so it show out all the row.
i'm accessing date field in Oracle 10g. its not accepting other date formats other than for example : 01/JAN/09 (month in 3 chars)
how can i convert datetime object to this formart using c# ?
I have a MySQL database with a field of type DateTime. When I try to send a date to the DB with the following format:
[Code]....
It does not save the time, only the date and a "00:00:00" at the end. For instance12/1/2011 00:00:00Any idea how I can format save also hours, minutes and seconds? Would it be best to use Timestamps?
i am developing a webaaplication ASP.net using C# and MYSQL as backend..
i am facing problem to execute this query in MYSQL:
SELECT ID, Date, Event, Remark, school, section, class, schooltype, shift
FROM sessioncalendar
WHERE (school = 'SECONDARY SCHOOL') AND (class = 'IX') AND (section = 'B') AND (shift = 'SHIFT I') AND (schooltype = 'XYZ School')
AND MONTH ( Date )= '6'
AS the query works well wethout addind AND MONTH ( Date )= '6' ... but when i add this line query generate error
( Error in list of function arguments: ')' not recognized. Unable to parse query text.)
While same query is working successfully with Sql Server 2005...but i hvnt found any reason why my query is not working with Date(datetime) column..i hv google about it..but i found synatax is same in both SQL SErver 2005 and MY SQL syntax
I've been looking around the web for a simple and straight forward solution for the following problem but I cant seem to find anything that suits my needs. I have an asp.net site with many subdirectories as follows.
[URL]
On each of my sites pages I need to extract the URL to the page minus the pagename and querystring. So if the page name was [URL]? param=5śm2=9 I would need the following [URL] I cant find any properties of the httprequest object that make this URL format readily available.
I Have a Data Bound TreeView.
I want the parent node value node to expand and view Cild nodes,
I would not have plus or minus signs or arrows or something like that.
Regarding your excellent gridview inside gridview, how i can change the jquery so i can use + and - text characters instead of images, i would use an achor tag for this in the gridview;
<a href="#">+</a>
I would like to write Set difference minus operation with Linq on list objects using Except method. [Code]....
Tha above code always returns lstrbb objects.
I created a UserControl and added a public DateTime property. I want to set this property in Markup (ie. <cc1:MyControl runat="server" id="MyControl1" DateTimeProp="1/1/2010" /> ) however I live in a place with a dd/mm/yyyy date format so it complains if I set something like "20/1/2010". Is there a way to set markup in my local datetime format or do I have to conform to "mm/dd/yyyy"?
View 2 RepliesI have a problem:
I've created usual Controller and View(Edit view) for editing my Entity (EntityFramework)
Here is view example:
<div class="editor-field">
@Html.EditorFor(model => model.BirthDate)
@Html.ValidationMessageFor(model => model.BirthDate)
</div>
BirthDate is Nullable<DateTime>
but during loading my View I get this exception
The model item passed into the dictionary is null, but this dictionary requires a non-null model item of type 'System.DateTime'.
That's because of BirthDate is null in database but it is nullable and I expect that it just leaves the filed empty.
And I have Shared EditorTemplate:
@model System.Nullable<System.DateTime>
@if (Model.HasValue)
I have an XML string which contains Dates formatted "dd/MM/yyyy hh:mm:ss".
I'm loading this XML into a dataset using DataSet.ReadXml().
How can I ensure that this Date is stored in the DataSet as a typed DateTime so that I can Sort, Format and RowFilter on it accordingly.
My test harness is as below:
ASPX Page:
[code]....
obj.From = DateTime.Parse(txtFrom.Text, ci);
And it will give error String was not recognized as a valid DateTime. How it can be solved..
How show local time in datagridview collumn DateTime from database with universal datetime
View 2 RepliesI 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 am selecting some data from a access database which is in Date/Time format in the Database and also in the programme the variable the information is stored in is registered as Date/Time.
However when I run the programme it says there is a data type mismatch.
[Code]....
Members 'System.DateTime modDate' and 'System.DateTime insertDate' both marked as row version.modDate and insertDate is a SQL Server database field with smalltimedate as data type.
View 2 Repliesi 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 want to develop a data access layer ,it can support multiple database like oracle ,Mssqlserver and Mysql using enterprise library and C#.net 3.5 based on database connection
View 1 RepliesUsing ASP.Net/VB.Net 2005.
I have an accordian inside a nested gridview that is controlled by an imagebutton. The Imagebutton is a plus sign "+" and the expand/collapse functionality is working great.
What I need to do is when the user expands the accordian is to change the plus ("+") sign to a minus ("-") image. I am trying to do this with javascript but its not working.
DateTime.Parse("07/23/2010")Gives "String was not recognized as a valid DateTime."
View 10 RepliesI have a Visual Studio 2008 solution that when I build, returns the following error:
Ticks must be between DateTime.MinValue.Ticks and DateTime.MaxValue.Ticks. Parameter name: ticks
There is no reference file/line/column in the error. Becoming quite frustrating as the solution builds in the end, however I cannot debug.In the solution, there is no reference/using to DateTime.MinValue.Ticks at all...
EDIT:
There are only 2 references to ticks in my solution, and neither of those are causing the issue.There are no constructor issues with DateTime either. I do not believe it is related to DateTime or ticks at all.I have found a similar reference where it turned out to be a corrupt image file in the solution, where it did not have a date-modified value. This is not affecting mine though.
I have a web site which uses one SQL database but the hosting company is very slow sometimes and I got database timeout, login and similar errors. Can I implement my code to use two databases simultaneously? I have stored procedures and the data is updated periodically.
EDIT:
Simply: When dbDefault is down and inaccessible I need to use dbSecondary so the web app keeps running. Ant these two databases must be always same.
EDIT:
Some errors:
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.Cannot open database "db" requested by the login. The login failed. Login failed for user 'root'.