Re: SQL selecting on date

Article View: borland.public.vdbase.forms

Article #333

Back to borland.public.vdbase.forms Previous Next

#333

From: Romain Strieff [TeamB]
Date: Thu, 25 Feb 1999 00:00

29 lines
1724 bytes

In article <VA.00000102.0018b2a2@jpddb>, Jose Luis Perez Diez politely 
paraphrased ...
> 
> Yes but that is one minute past midnight.
---
No, 1 minute after the day has begun.<G> 

> ?Ctodt("24.2.99")+iif(Ctodt("24.2.99")=Ctod("24.2.99"),"=","<>");
>  +Ctod("24.2.99")
> ?Ctodt("24.2.99 00:00:00.01");
>  +iif(Ctodt("24.2.99 00:00:00.01")=Ctod("24.2.99"),"=","<>");
>  +Ctod("24.2.99")
> Outputs:
> 24/02/99 00:00:00=24/02/99
> 24/02/99 00:00:00<>24/02/99

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?

I thought _I_ was trying to tell _you_ that.<G>

-- 
Romain Strieff [TeamB]
Please read this newsgroup guide below before 
posting on the private Inprise newsgroups.
http://www.inprise.com/newsgroups/guide.html
--

Technical Details

Message-ID: <MPG.113f62a1556c1fd0989ec2@forums.inprise.com>

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>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 15bdfb,5ea149ed5131c381
X-Google-Attributes: gid15bdfb,public
From: teamb@opto-pps.com (Romain Strieff [TeamB])
Subject: Re: SQL selecting on date
Date: 1999/02/25
Message-ID: <MPG.113f62a1556c1fd0989ec2@forums.inprise.com>
X-Deja-AN: 448331921
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>
Organization: TeamB
Newsgroups: borland.public.vdbase.forms

Reply to Parent Message