Re: SQL Current Time and Date

Article View: borland.public.interbase.sql

Article #11183

Back to borland.public.interbase.sql Previous Next

#11183

From: justdoro
Date: Mon, 09 Dec 2002 14:57

17 lines
1578 bytes

Check out the current_date, current_time, and current_timestamp routines 
in the manual.

For example,

select current_date, current_time, current_timestamp
   from rdb$database;



Patrick Lauber 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?
> 
>

Technical Details

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

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!38.144.126.75.MISMATCH!feed1.newsreader.com!newsreader.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newshosting.com!news-xfer1.atl.newshosting.com!uunet!dca.uu.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 07:07:24 PST
Date: Mon, 09 Dec 2002 09:57:43 -0500
From: justdoro <justdoro@attbi.com>
User-Agent: Mozilla/5.0 (Macintosh; U; PPC Mac OS X; en-US; rv:1.2.1) Gecko/20021130
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: Re: SQL Current Time and Date
References: <3df49d86@newsgroups.borland.com>
In-Reply-To: <3df49d86@newsgroups.borland.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 12.245.211.122
Message-ID: <3df4af60@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1039445856 12.245.211.122 (9 Dec 2002 06:57:36 -0800)
Lines: 18
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!38.144.126.75.MISMATCH!feed1.newsreader.com!newsreader.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newshosting.com!news-xfer1.atl.newshosting.com!uunet!dca.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message