Re: SQL selecting on date

Article View: borland.public.vdbase.forms

Article #338

Back to borland.public.vdbase.forms Previous Next

#338

From: Jose Luis Perez Diez
Date: Fri, 26 Feb 1999 00:00

17 lines
1582 bytes

In article <MPG.113f62a1556c1fd0989ec2@forums.inprise.com>, Romain Strieff 
[TeamB] wrote:
> Mmm what are you trying to tell me? That if the timepart in a Datime 
> stamp (automatically stamped at each change in a table for example, and 
> so always never 00:00:00) differs from 00:00, comparisions may not be 
> what your think?
Yes 
>  
> I thought _I_ was trying to tell _you_ that.<G>
>

Reading your message I found that the OLH tells us two under Timestamp:
"Primitive dates represent the date only, not the time. (They are considered to 
be the first millisecond�midnight�of that date.)"

Jos� Luis P�rez Diez

Technical Details

Message-ID: <VA.00000105.01374ec0@jpddb>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References:

<36C94775.33317295@skynet.be> <36d07f65.81835433@forums.borland.com> <VA.000000fb.00bff26d@jpddb> <MPG.1134df6cc483f7b989e06@forums.inprise.com> <VA.000000fe.00023d43@jpddb> <MPG.1137742ddac03db5989e49@forums.inprise.com> <VA.000000ff.01454be9@jpddb> <MPG.113bb9f52995f9b7989e97@forums.inprise.com> <VA.00000100.0084a3ad@jpddb> <MPG.113cb9bde9f3ca8e989ea6@forums.inprise.com> <VA.00000102.0018b2a2@jpddb> <MPG.113f62a1556c1fd0989ec2@forums.inprise.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 15bdfb,5ea149ed5131c381
X-Google-Attributes: gid15bdfb,public
From: Jose Luis Perez Diez <NOMAIL@Jluis.es>
Subject: Re: SQL selecting on date
Date: 1999/02/26
Message-ID: <VA.00000105.01374ec0@jpddb>
X-Deja-AN: 448707073
Content-Transfer-Encoding: 8bit
References: <36C94775.33317295@skynet.be> <36d07f65.81835433@forums.borland.com> <VA.000000fb.00bff26d@jpddb> <MPG.1134df6cc483f7b989e06@forums.inprise.com> <VA.000000fe.00023d43@jpddb> <MPG.1137742ddac03db5989e49@forums.inprise.com> <VA.000000ff.01454be9@jpddb> <MPG.113bb9f52995f9b7989e97@forums.inprise.com> <VA.00000100.0084a3ad@jpddb> <MPG.113cb9bde9f3ca8e989ea6@forums.inprise.com> <VA.00000102.0018b2a2@jpddb> <MPG.113f62a1556c1fd0989ec2@forums.inprise.com>
Content-Type: text/plain; charset=iso-8859-1
Organization: My Company
Mime-Version: 1.0
Reply-To: NOMAIL@Jluis.es
Newsgroups: borland.public.vdbase.forms

Reply to Parent Message