Re: Handling Dates

Article View: borland.public.interbase.sql

Article #11314

Back to borland.public.interbase.sql Previous Next

#11314

From: Antonio Felix
Date: Wed, 27 Nov 2002 14:34

16 lines
1304 bytes

"Andrew Jameson" <contact@softspotsoftware.com> wrote:
>Hi,
>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 ?
>
>Andrew
>
>

Hi,
 Have you tried 
           CAST( YOURDT as DATE )

HTH
Antonio

Technical Details

Message-ID: <3de4d7e9$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-01!sn-xit-04!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!opentransit.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <3de4d2d0@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,dc814d740057dd36
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-11-27 06:40:46 PST
From: "Antonio Felix" <hafelix@mail.telepac.pt>
Sender: "Antonio Felix" <hafelix@mail.telepac.pt>
Reply-To: "Antonio Felix" <hafelix@mail.telepac.pt>
Subject: Re: Handling Dates
Newsgroups: borland.public.interbase.sql
X-User-Info: 195.245.190.93 195.245.190.93    
X-Forwarded-For: unknown
References:  <3de4d2d0@newsgroups.borland.com>
NNTP-Posting-Host: 207.105.83.65
Message-ID: <3de4d7e9$1@newsgroups.borland.com>
Date: 27 Nov 2002 06:34:17 -0800
X-Trace: newsgroups.borland.com 1038407657 207.105.83.65 (27 Nov 2002 06:34:17 -0800)
Lines: 16
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-01!sn-xit-04!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!opentransit.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message