.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

How to change date to End of Day?

Posted By:      Posted Date: September 03, 2010    Points: 0   Category :Sql Server
I want to convert a date value to the end of the day.  For instance, '9/1/2010 3:45pm' --> '9/1/2010 11:59:59pm'.   Is there a way to do that without a messy bunch of casts on individual date parts?

View Complete Post

More Related Resource Links

change calendar date backColor base on data from db


I want to  change calendar date backColor base on data from db,  I only have vistual 2003 !

on mean time I have

<asp:DataGrid id="DataGrid1" style="Z-INDEX: 102; LEFT: 23px; POSITION: absolute; TOP: 271px"
		    runat="server" Font-Size="XX-Small" Font-Names="Verdana" AutoGenerateColumns="False" Visible="False">
           <asp:BoundColumn DataField="subject" HeaderText="Title"></asp:BoundColumn>
           <asp:BoundColumn DataField="posttimestart" HeaderText="Post date"></asp:BoundColumn>


Sub DayRender(ByVal source As Object, ByVal e As DayRenderEventArgs)
        Dim i As Integer
        For i = 0 To DataGrid1.Items.Count - 1
            If (DataGrid1.Items(i).Cells(1).Text = e.Day.Date) Then
                e.Cell.BackColor = Color.DarkOrange

            End If

    End Sub

when I click the day wich have data in db it change  color , but I want the page load it change color !

Thank you!

Change database fields automatically according to date

Hi, I'm currently developing a software application for my client. Part of the project is to keep track of his stock's shipping status. The client must insert the stock's pick-up date, expected time of departure (ETD) and expected time of arrival (ETA). The stocks will be called out using Grid View and the status, being one of the keys of the database, will be shown. Before the current date reaches pick-up date, the status must show "in warehouse", and after the current date reaches pick-up date and is before ETD, status must show that its "on the way to the port", and after ETD and before ETA, "in freight", and finally after ETA, "arrived". What datatype should I use for the database and where should I program it so that it changes automatically accordingly ?

Should time date stamp on .Asmx file change when project is rebuilt?

I have a web service project. The web service is named Recalc.asmx and it has a code behind file namedRecalc.asmx.vb Now if I make a change to my web service .vb code and then recompile the project, should my Recalc.asmx filebe updated as well? In windows explorer I see that the time date stamp of my Racalc.asmx.vb file changes to the date of the last change.But the time date stamp of the Recalc.asmx file does not change? Why is that? My original thinking was that I would simply need to copy the Recalc.asmx file to the test server. But the date stillshows it's original creation date of 7/1/2010 and not the date of the last rebuild as I was hoping it would do?

how to change date format

Hi,   I am using Oracle 10g im my asp.net project. In my select query, i want to change the format to dd/mm/yyyy hh:mm:ss from mm/dd/yyy hh:mm:ss. The field datatype is date. How can i write a query for this?

User cannot change the date value after its been saved. Why not?

I've got a DatePicker control on a WPF 4.0 page (not a XBAP).  It's pulling data find out of our SQL Server database, but boy, if the user tries to change the data, forget it!  And for the life of me, I cannot figure out why not.  Here's the relevant XAML: <DatePicker Name="dpDateOfBirth" SelectedDateChanged="dpDateOfBirth_SelectedDateChanged" Validation.Error="dpDateOfBirth_Error" GotFocus="dpDateOfBirth_GotFocus"> <DatePicker.SelectedDate> <Binding Path="DateOfBirth" NotifyOnValidationError="True"> <Binding.ValidationRules> <ExceptionValidationRule></ExceptionValidationRule> </Binding.ValidationRules> <Binding.Converter> <local:DateConverter></local:DateConverter> </Binding.Converter> </Binding> </DatePicker.SelectedDate> </DatePicker> and here's my DateConverter class: using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Windows.Data; using System.Windows; /* * This is the basic date converter, when no mask editing is involved. It just returns a date. */ namespace WpfRFS { [ValueConversion(typeof(DateTime), typeof(string))] public class DateConverter : IValueConverter { public object Convert(object value, Type targetT

Change the Default Date in the Date Picker Control

Hi, I have a WPF Datagrid in which one of the columns is a Date Column. So i have used a DataTemplateColumn as Follows     <my:DataGridTemplateColumn CellTemplate="{StaticResource EffDateDateTimePickerControl}"   CellEditingTemplate="{StaticResource addrEffDate}" Header="Effective Date"/> And in my Resource File i have written the following code: Style   TargetType="{x:Type my:Calendar}" x:Key="CalenderControlTemplate">     <Setter Property="Template">     <Setter.Value>     <ControlTemplate TargetType="my:Calendar" >     <my:CalendarItem Name="myCalendarItem"   Background="White"   BorderBrush="Black"   BorderThickness="1"   VerticalAlignment="Center" />     </ControlTemplate>       </Setter.Value>     </Setter>     </Style>       <DataTemplate x:Key="EffDateDateTimePickerControl">     <Label x:Name="lblEffDate" Content="{Binding effectiveDate,Mode=TwoWay}" ></Label>     </DataTemplate>     <DataTemplate x:Ke

change the date rang in calendar depend on the data from db

if the calendar day is match with the date in db I can change the claendar 's background color  with the following code , How if I want  my calendar change color by the range of the data in my db ,  said I want the calendar change color from the starDay to endday of the event , the date rang is random what can I do ??  For Each dr In tmpds.Tables(0).Rows                    If Not dr("startDay") Is DBNull.Value Then                        Dim dtEvent As DateTime = dr("startDay").ToString

how do i change date format??


hey Guys,

I have a table with a date field that had date saved in the format of
yyyy-mm-dd, what i want to achieve is when I display them I want them to be displayed as an example "September 05 2009" format. can anybody help me with this??

Thank you very much.

How to change the date format using AJAX calendar control tookit


I want to desplay date like (21-Sep-2010)

adhoc reporting - data doesn't refresh on date range change


I created an adhoc report model using SQL Server 2008 reporting services. I am using data from a SQL 2000 database sitting on a SQL 2000 server. I created reports with start date and end date parameters, everything worked fine.


Now my ad hoc report model uses a SQL 2000 database (this database is a replication of the database I was using)  sitting on a SQL 2008 server. When I change parameters like start date and end dates, data doesn’t refresh. It shows the same data for any date range.


Has anyone seen this problem? What could be done to fix the issue. Is there any setting on the SQL server to fix this?



How to change a date format in GridView?


Hello all,

I'm new here - just started, and already have a problem...


From the database - 2 of my GridView cells: From Period, and Till Period - retrieve dates in the format YYYYMM - that is: just Year and Month. For Example:

Till Period
From Period

  200008 200005

  200011 200009


I want for the date to be displayed in the Grid at the following format MM/YYYY - that is:

Date Format Change in GridView


Hello all,

I'm new here - just started, and already have a problem...

From the database - 2 of my GridView cells: From Period, and Till Period - retrieve dates in the format YYYYMM - that is: just Year and Month. For Example:

Till Period
From Period
Till Period
From Period

  200008 200005

  200011 200009


I want for the date to be displayed in the Grid at the following format MM/YYYY - that is:

Till Period
From Period

Regional settings (locale) in SP - is there any way to change that settings? eg. date format

The system I use is MOSS2007. I have regional settings set to "Polish". The default date format is yyyy-mm-dd, what is wrong because usually is dd-mm-yyyy. Is there any way to change specific regional settings? I couldn't have found it on internet. I've tried to change to "French", which gives me dd-mm-yyyy, but then eg. in calendar I have days and months in French language :)

Change the date format of calendar web part



I have displayed summary view of calendar web part and want to change the date format from 10-24-2010 to 10-24 I don’t want to display the year can anyone help me please


Change date format


I am getting date on my aspx page as

10/22/2010 11:52:07 AM

How can i change the format so that i becomes:

22 Oct 2010 11:52 AM


Change one date in a sharepoint 2007 calendar series linked to a meeting workspace

How can do I change one date of a meeting in a series linked to a meeting workspace in SharePoint 2007?

Plz help me to change date format


                <div style="width:100%; height:150px; background-color:#cae2eb;">
                    <div style="float:left; margin-left:10px; text-align:center; height:150px; width:400px; margin-top:5px;">
                        <p style="font-weight:bold; padding-top:10px;"><%#DataBinder.Eval(Container.DataItem, "EventFrom").ToString("MMM dd, yyyy")%></p>
                        <p style=&quo
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend