SQL Current Time and Date

Thread View: borland.public.interbase.sql

4 messages

[T] Back to Threads [V] Tree View [G] Group Articles

4 total messages Started by Patrick Lauber Mon, 09 Dec 2002 13:42

#11180

Author: Patrick Lauber
Date: Mon, 09 Dec 2002 13:42

4 lines
1185 bytes

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?

Re: SQL Current Time and Date

#11181

Author: Martijn Tonies
Date: Mon, 09 Dec 2002 14:11

20 lines
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."

Re: SQL Current Time and Date

#11182

Author: 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)

Re: SQL Current Time and Date

#11183

Author: 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?
> 
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads