Article View: borland.public.interbase.sql
Article #1037Re: Round a DateTime
From: Robin
Date: Mon, 19 Mar 2007 22:52
Date: Mon, 19 Mar 2007 22:52
20 lines
1453 bytes
1453 bytes
Svein Erling Tysv�r wrote:
> Why not simply
>
> CAST(MyDateTimeField as Date)
>
Because it doesn't work for me either :-p. I still get the time portion.
> select cast(cast('19.03.2007 14:25:23:8532' as Timestamp) as Date)
> from rdb$database
Now *that* I hadn't thought of! But alas, no luck for me there either.
I am also in FB 1.5. So very strange.
--
Robin.
Australian Bridal Accessories := http://www.bridalbuzz.com.au
Turbo for Noobs (a work in progress) := http://turbofornoobs.blogspot.com/
Technical Details
Message-ID:
<45ff141a@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<45fe1225@newsgroups.borland.com> <45fe6022@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,cf698e5e2a79f5a0 X-Google-Attributes: gid114a0e,public X-Google-Language: ENGLISH,ASCII Date: Tue, 20 Mar 2007 09:52:31 +1100 From: Robin <Robin@.com> User-Agent: Thunderbird 1.5.0.7 (Windows/20060909) MIME-Version: 1.0 Newsgroups: borland.public.interbase.sql Subject: Re: Round a DateTime References: <45fe1225@newsgroups.borland.com> <45fe6022@newsgroups.borland.com> In-Reply-To: <45fe6022@newsgroups.borland.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit NNTP-Posting-Host: 165.228.6.111 Message-ID: <45ff141a@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1174344730 165.228.6.111 (19 Mar 2007 15:52:10 -0800) Lines: 20 Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail