Re: SQL selecting on date

Article View: borland.public.vdbase.forms

Article #331

Back to borland.public.vdbase.forms Previous Next

#331

From: Jose Luis Perez Diez
Date: Thu, 25 Feb 1999 00:00

19 lines
1400 bytes

In article <MPG.113cb9bde9f3ca8e989ea6@forums.inprise.com>, Romain Strieff 
[TeamB] wrote:
> dt1= ctodt("24.02.99 00:01:00")
> d=    ctod("24.02.99")
>  
> ? dt1=d //false
> ? d=dt1 //false
>
Yes but that is one minute past midnight.
?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

Jos� Luis P�rez Diez

Technical Details

Message-ID: <VA.00000102.0018b2a2@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>

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/25
Message-ID: <VA.00000102.0018b2a2@jpddb>
X-Deja-AN: 448230647
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>
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