SELECT m1.Column1, m1.Column2, m1.Column3, r.MaxTime FROM ( SELECT Column1, MAX(TimeColumn) as MaxTime FROM MyTable GROUP BY Column1 ) r INNER JOIN MyTable m1 ON m1.Column1= r.Column1AND m1.TimeColumn = r.MaxTime
Tag: date
How to Validate a DateTime in C#?
DateTime myDate; if(DateTime.TryParse(txtBirthDate.Text, out myDate)) { //Valid Date } else { //Invalid Date }
How to use Html.TextBox for Date in Asp.Net MVC
@Html.TextBox(“BookName”, Model.Books.BookName, new { @class = “form-control”, @type = “date” })
How to return only the Date part from SQL Server DateTime datatype
Date and Time Conversions in SQL Server
SQL Server provides a number of options you can use to format a date/time string. One of the first considerations is the actual date/time needed. The most common is the current date/time using getdate(). This provides the current date and time according to the server providing the date and time. If a universal date/time is needed, […]
How to change ReportViewer Date Format
How to return only the Date from a SQL Server DateTime datatype
–You can change GETDATE() with the date you want to use SELECT CONVERT(date, GETDATE())