Re: Handling Dates

Article View: borland.public.interbase.sql

Article #11319

Back to borland.public.interbase.sql Previous Next

#11319

From: Andrew Jameson
Date: Wed, 27 Nov 2002 15:30

31 lines
2284 bytes

Hi Guys ...

Thanks Craig ... I tried that Cast but it doesn't work ... essentially I
wanted to truncate the TimeStamp to eliminate or zero the time ... it's an
inherited database port from SQL Server and although I don't need the time,
the data is populated with non-zero time ... consequently equality tests
involving dates can become dependent on the time ... which I don't want !

Solved it anyway ... shifted it to Dialect 3 and converted all of the
TimeStamp definitions to Date !

Andrew

Craig Stuntz [TeamB] <cstuntz@nospamplease.com (but use vertexsoftware to
email)> wrote in message
news:MPG.184ea22a727a113d98a28a@newsgroups.borland.com...
> In article <3de4d2d0@newsgroups.borland.com>, contact@softspotsoftware.com
> says...
> > I'm using SQL Dialect 1 and sadly the Date function returns the time as
well
> > ... I only want the date ... how do you do it ?
> >
> You only want the date in which context?
>
> -Craig
>
> --
> Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH
> Delphi/InterBase Weblog : http://delphi.weblogs.com
> InterBase Perf. Monitor : http://delphi.weblogs.com/IBPerformanceMonitor
> InterBase PLANalyzer 1.1: http://delphi.weblogs.com/IBPLANalyzer

Technical Details

Message-ID: <3de4e44e@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-04!supernews.com!news.maxwell.syr.edu!newsfeed.frii.net!newsfeed.frii.net!news.compaq.com!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <3de4d2d0@newsgroups.borland.com> <MPG.184ea22a727a113d98a28a@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 114a0e,dc814d740057dd36
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-11-27 07:39:29 PST
From: "Andrew Jameson" <contact@softspotsoftware.com>
Newsgroups: borland.public.interbase.sql
References: <3de4d2d0@newsgroups.borland.com> <MPG.184ea22a727a113d98a28a@newsgroups.borland.com>
Subject: Re: Handling Dates
Date: Wed, 27 Nov 2002 15:30:09 -0000
Lines: 33
Organization: SoftSpot Software
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
NNTP-Posting-Host: 213.48.231.98
Message-ID: <3de4e44e@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1038410830 213.48.231.98 (27 Nov 2002 07:27:10 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-04!supernews.com!news.maxwell.syr.edu!newsfeed.frii.net!newsfeed.frii.net!news.compaq.com!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message