Re: Date Types and Time Granularity

Jon Myers wrote:
>
> Force all the dates to have the same time? Maybe run the values through the
> datevalue() function to strip out time values (time is midnight by default,
> I think).
>
> Just a quick thought.
> Jon M

Yes, that is certainly an option, Jon. I guess I was looking for a solution that would both be enforced at the RDBMS level and also convenient to work with.

-- 
% Randy Yates                   % "I met someone who looks alot like you,
%% DIGITAL SOUND LABS           %             she does the things you do, 
%%% Digital Audio Sig. Proc.    %                     but she is an IBM."
%%%% <yates_at_ieee.org>           %        'Yours Truly, 2095', *Time*, ELO   
http://207.87.184.178/index.htm