I have an Output clause in a SQL statement and I use getutcdate() for a record. Does UTC record seconds? If so, how do I display it? What data type should I use for the UTC field?
View 13 Replies
I am trying to get all records 7 days from the Purchase date field using this query:
SELECT DATEADD(dd, 7, dtPurchaseDate) FROM CustomerProduct
This doesn't seem to work because it is giving me dates from 2002, 2003, etc. What am I doing wrong.
I am filtering dataview using my Date Column but the result is not proper because the Field value also stores time, so I want to convert this Date Field to only Date during Filter. How can I achieve this? Here is my code. And the actual value I am getting in the Dataset Field "CreationDate" is a DateTime field which is like
2010-01-21 14:35:25.203
2010-01-22 12:55:18.033
2010-01-26 12:10:06.990
But I only want to neglet time value and want to compare Date only.
[Code]....
I'm trying to update a date field to the system date but it's not working. Could someone please help with the syntax?
[Code]....
I have a form that contains a text box called "MyDate" in which the user enters a date. I have a table that contains records of which one of the fields in the record is a date field named "DateAvailable" (type is "datetime"). I want to compare the data in the text box to the "DateAvailable" field in record. How do I define my text box as a "datetime" field.
View 2 RepliesI want to store value like 01,02,03 in database but whenver i do so the database transfor those figures into 1,2,3. The field is Int Type.
View 4 RepliesI'm trying to compare a parameter of type String with a database field of type ntext. Below is my vb code. carDescription is a field in the database table that is of type ntext. The code didn't work because you can't use the equality operator.
Dim carDescriptionLookupCmdString As String = "SELECT carMake FROM car WHERE carDescription = @description"
Dim carDescriptionLookupCmd As New SqlCommand(carDescriptionLookupCmdString, dbConnection)
carDescriptionLookupCmd.Parameters.AddWithValue("@description", description)
Dim reader As SqlDataReader = carDescriptionLookupCmd.ExecuteReader()
I am using the following query to comapare the value of column of datetime type with the server date
select * from Tbl_MyTable where DATEADD(day, DATEDIFF(day,0,[Date]),0)=DATEADD(day, DATEDIFF(day,0,getdate()),0)
but with this I am not getting any out put .
how to compare two dates if the above way is not accurate
how do i insert date and time together ? what is the format for this. i tried like this but its not working.
string startDtime = TextFromDate.Text + " " + Stime;
sql_comm.Parameters.AddWithValue("@StartDate",
DateTime.Parse(startDtime));
is this the right way ? dd/mm/yyy +" "+ 00:00
or i need to make a string that contain this : dd/mm/yyy00:00
its not writing any eror it just do nothing .
I want to filter a datetime field for a date without the time...
I want all fields that contain the selected date regardless of the time.
What should I use as the filter expression?
I have the following problem: I need to store in MS SQL Server 2005 a vary large text in to one field of type nvarchar(MAX), In spite of the configuration is apparently correct I keep receiving the following message in the exception: "string or binary data would be truncated".
View 1 RepliesI want to read date field from Excel sheet and insert it into SQL Server2005.When I read date field it gives me a number say '40160' when the date feild is "08/01/2010"
How should to Read a date field from Excel Sheet Cells?
I have this error "The given value of type String from the data source cannot be converted to type datetime of the specified target column." when I used sqlbulkcopy to do the transaction
Here is my code:
[code]....
I have a page with a FormView on it. The page is strictly for adding records to a Table. I have the FormView bound to an EntityDataSource and everything works greate except for one thing.
I want to initialize a date field in the FormView to today's date. So, in my page_load event I have:
if (!Page.IsPostBack)
{
//Initialize SetupDate to today.
TextBox setupdate = (TextBox)fvJob.FindControl("txtSetupDate");
setupdate.Text = DateTime.Now.ToShortDateString();
}
The first time this page loads, the txtSetupDate field is initialized.
Although, and subsequent loads of the page doesn't initialize the Text Box. I step through the code in the debugger and I can see that the code is executig, but something (the FormView bind?) is "clearing" the Text Box.
I have a databound gridview that displays basic customer information. I have added a template field to the gridview, but I am having trouble with the coding for the RowDataBound event. I need to take the sum of all payments made by the customer in each row and store it in a variable for further calculation. Also, I need to take an integer value (say 30, representing 30 days) and add it to a date, and return a date.
View 14 RepliesI have the following:
[code]....
I keep getting this error:
Message = "The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value."
What i'm trying to do is group by ContentObjectId and then get StartDate that is greater than today.
I'm using entity framwork and MS SQL2008
I would like column in a table to be a link(not using hyperlink field). What data type do I need to use to make this possible?
View 2 RepliesI am gettinga syntex error. Is Primary field is a bit data type in the database.
<asp:TemplateField HeaderText="IsPrimary">
<EditItemTemplate>
<asp:CheckBox runat="server" ID="chkIsPrimary" Checked='<%# Eval("IsPrimary").ToString() == "1"? true : false %>' />
</EditItemTemplate>
</asp:TemplateField>
nested repeater like this:
<asp:Repeater ID="repeaterReportListByJob" runat="server" DataSource='<%# GetReportsByJobNID(Eval(Container.DataItem, "JobNID")) %>'>
It seems my Eval(Container.DataItem, "JobNID") is not working and I assume this is because the datasource of the outer (parent) repeater is an anonymous type. So how am I supposed to access a particular field of my anonymous type?
<ItemTemplate>
<asp:LinkButton ID="lblRevision" runat="server" CssClass="Textboxes" Text='<%# DataBinder.Eval(Container.DataItem, "RevNo")%>' CommandName="FileDownloadRecord"></asp:LinkButton>
</ItemTemplate>
how to change the linkbutton color based on the DOCID value (another field which is coming via databind) which is 1 or 0 bit type boolean value.
i have created a table with column like date (datetime), employeename (varchar) and their designation (varchar).. am using sql server 2005 and vb.net
I want to display this information in gridview.. i also displayed the inforamtion, but what the problem is the display of date is 4/2/2010 12:00:00 AM.. i need to display only the date in the gridview as 4/2/2010 under the date column .
I have an "effectivedate" field that is displayed using a label inside a detailsview control... In the code behind I need to add 12 months to this to check if a policy is up for renewal or not...
To find the control I use this code... Dim EffectiveDate As Label = DetailsView1.FindControl("EffectiveDatelbl").ToString
But when I try and convert the label to datetime type using this... Dim ExpireDate As DateTime = EffectiveDate.AddMonths(12)
I get the error - Cannot convert string to date, addmonths is not a member of label etc...
How can I format my date field like this "Jan 6 @ 7:42 AM" from my date field. My present date field is in this format "1/6/2010 7:42:00 AM".
I am using this in my repeater control.
I have a gridview that has a field called TargetDate which is formatted as dd/mm/yyyy. I want to substring the numbers out of the date. So basically remove the '/'. How do I do that? can't just substring(0,2) because sometimes the date is single digits, sometimes 2 digits. I am using vb.net.
View 2 RepliesI have an application that I would like to be able to allow the user to modify multiple characteristics of each record within a datagrid.
Most characteristics require data to be entered in a text box but some a check box would be more appropriate.
My question is does a gridview column need to have all the same item template controls? or could I read from the database the control type and dynamically alter the template control for each row as it loads?
