Ask a Question related to ASP.NET General, Design and Development.
-
g-fro #1
filter by time
My stored procedure is below. I would like to be able to take the
delaydata.timestamp field and grab only the records during a certain
hour. How would I go about doing this? Currently I filter by Cell,
Date and User.
<************BEGIN STORED PROCEDURE *********>
ALTER PROCEDURE dbo.GetDelayData
@startDate as datetime,
@endDate as datetime,
@cell as nvarchar,
@user as nvarchar(20)
AS
SELECT *
FROM
DelayData
WHERE
(Convert(datetime,DelayData.TimeStamp) between @startdate and
(@endDate + 1))
and (DelayData.cell=@cell OR @cell='*')
and (DelayData.UserName=@user OR @user='*')
Order by Convert(datetime,DelayData.TimeStamp) ASC
<***********END PROCEDURE*******>
TimeStamp is the name of the field. I don't like the naming
conventions in this table but it is not a table created by me. I
would think this would be rather easy to do, but I haven't been able
to find any documentation on this.
Any help would be appreciated.
g-fro Guest
-
#40499 [NEW]: filter sapi does not register any highlightning filter
From: php at henke37 dot cjb dot net Operating system: any PHP version: 6CVS-2007-02-15 (CVS) PHP Bug Type: Apache2 related... -
CFMX7.0.1 Administrator date time issue showing 13hrsbehind server time
I am running a W2k SP4 box that has been upgraded from CFMX6 to CFMX7.0.1. The CFMX7.0.1 server is showing the date on the Server Settings >... -
Data Grid Header Filter Renderer or how do I get aheader to filter the data in a datagrid.
Okay so on the same theme as why isn't the datagrid like Excel, I have created a (very cool) Filter header. 1) The filter looks like any other... -
Filter records by date and time
any chance to help me on this pls .. can anyone tell me how i can sort my table by date and time i wanna put down specific DATE and TIME into my db... -
Formatting a time field to 24 hour time (Military time) in the Datagrid
Anyone know how to do this?



Reply With Quote

