Re: SQL Current Time and Date

Article View: borland.public.interbase.sql

Article #11182

Back to borland.public.interbase.sql Previous Next

#11182

From: Bill Todd
Date: Mon, 09 Dec 2002 14:18

19 lines
1443 bytes

CURRENT_TIMESTAMP
CURRENT_TIME
CURRENT_DATE

assuming a dialect 3 database.

On Mon, 9 Dec 2002 14:42:40 +0100, "Patrick Lauber"
<patrick.lauber@detewe.ch> wrote:

>I would like to compare with a select-command the current system time with a
>field from a table
>are there functions for the current time and date in use with
>select-commands?
>


--
Bill (TeamB)
(TeamB cannot respond to questions received via email)

Technical Details

Message-ID: <8g99vukpvujike59b241ubuk16a0r3taeg@4ax.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed-west.nntpserver.com!hub1.meganetnews.com!nntpserver.com!telocity-west!DIRECTV!203.109.225.2!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,9bc4fb9d85ba6542
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-09 06:26:32 PST
From: Bill Todd <bill@notthis.dbginc.com>
Newsgroups: borland.public.interbase.sql
Subject: Re: SQL Current Time and Date
Date: Mon, 09 Dec 2002 07:18:20 -0700
Message-ID: <8g99vukpvujike59b241ubuk16a0r3taeg@4ax.com>
References: <3df49d86@newsgroups.borland.com>
X-Newsreader: Forte Agent 1.91/32.564
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 216.207.211.30
X-Trace: newsgroups.borland.com 1039443499 216.207.211.30 (9 Dec 2002 06:18:19 -0800)
Lines: 19
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed-west.nntpserver.com!hub1.meganetnews.com!nntpserver.com!telocity-west!DIRECTV!203.109.225.2!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message