BorlandTalk.com

Larry Killen · Guest

I played around for 5 minutes and this is the best I could come up with.
Seems I could do better.

Is there something more elegant?

SELECT [RecNum], [DateWeighed]
FROM [GaincoData].[dbo].[ProductionData]
WHERE DateWeighed > (GETDATE()-1)

Patrick · Guest

I use this:

WHERE CONVERT(VARCHAR(20),CONVERT(DateTime,(<insert fieldname here>)),101) =
CONVERT(VARCHAR(20),CONVERT(DateTime,(GetDate())),101)

"Larry Killen" <LarryKillen (AT) Gainco (DOT) Com> wrote

Patrick · Guest

Maurice Telkamp · Guest

"Larry Killen" <LarryKillen (AT) Gainco (DOT) Com> wrote

Roman Krejci · Guest

"Larry Killen" <LarryKillen (AT) Gainco (DOT) Com> pí¹e v diskusním pøíspìvku
news:4241e6f3$1 (AT) newsgroups (DOT) borland.com...

Tomislav Kardaš · Guest

Hi Larry!

On Wed, 23 Mar 2005 16:57:58 -0500, "Larry Killen"
<LarryKillen (AT) Gainco (DOT) Com> wrote:

Stephan Marais · Guest

Not sure about performance, but the below might more elegant:
Write a udf.

create function udf_striptime(@thedate datetime)
returns datetime as
begin
declare @hour int
declare @min int
declare @sec int
declare @msec int
declare @result datetime

select @hour = datepart(hh, @thedate)
select @min = datepart(mi, @thedate)
select @sec = datepart(ss, @thedate)
select @msec = datepart(ms, @thedate)

select @result = dateadd(hh, -@hour, @thedate)
select @result = dateadd(mi, -@min, @result)
select @result = dateadd(ss, -@sec, @result)
select @result = dateadd(ms, -@msec, @result)

return @result
end

Then you can use SQL like

SELECT [RecNum], [DateWeighed]
FROM [GaincoData].[dbo].[ProductionData]
WHERE DateWeighed > dbo.udf_striptime(getdate())

Stephan Marais

Larry Killen wrote: