Article View: borland.public.interbase.sql
Article #11181Re: SQL Current Time and Date
From: Martijn Tonies
Date: Mon, 09 Dec 2002 14:11
Date: Mon, 09 Dec 2002 14:11
20 lines
1472 bytes
1472 bytes
CURRENT_TIME, CURRENT_DATE and CURRENT_TIMESTAMP > 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? -- With regards, Martijn Tonies InterBase Workbench - the developer tool for InterBase Firebird Workbench - the developer tool for Firebird Upscene Productions http://www.upscene.com "This is an object-oriented system. If we change anything, the users object."
Technical Details
Message-ID:
<3df4a3d4@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<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:09:10 PST From: "Martijn Tonies" <m.tonies@upscene_remove.com> Newsgroups: borland.public.interbase.sql References: <3df49d86@newsgroups.borland.com> Subject: Re: SQL Current Time and Date Date: Mon, 9 Dec 2002 15:11:08 +0100 Lines: 22 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 NNTP-Posting-Host: 212.238.179.102 Message-ID: <3df4a3d4@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1039442900 212.238.179.102 (9 Dec 2002 06:08:20 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail