>My biggest beef in SQL Server is the lack of Date fields (without time).
>I am forever having to compare dates from '00:00' to '23:59' when the time is absolutely irrelavent.
>I thought of using a character field to store dates but then the date functions are more complicated and there is no date checking...
>Anyway, your comments are welcome.
>For now, can someone tell me the easiest way to compare a datetime field with multiple times throughout the day to a single date (any time of day)?
Hi Darren,
You could always convert datetime to a string and trunc the timepart and then compare the fields. I use this very often when sending data from ASP to a sp. Use the convert on both datetime expressions to compare two dates.
create procedure sp_date
@date as varchar(10)
as
if isdate(@date) = 1
begin
if @date = convert(varchar(10), getdate(), 120) then
print 'Equals'
else
print 'Not Equals'
end
else
begin
print 'Not a date'
end
go
Magnus NordinVFP MCP
"We have tested the GUI on 5-year olds. Why? Beacuse they aren't braindead!"
Michael Spindler, Apple