Hi

I was using the Freeudflib for datetime functions until I learn Extract
function from this mail group.

I can do following statements with extract function:

select extract(day from current_timestamp) from rdb$database;
select extract(month from current_timestamp) from rdb$database;
select extract(year from current_timestamp) from rdb$database;
select extract(WEEKDAY current_timestamp) from rdb$database;

Is there any option of extract function.
Or is there any help about extract function.
Because I cant't find ecxtract fiunction in the interbase help.

----- Original Message -----
From: "Markus Ostenried" <chef_007@...>
To: <ib-support@yahoogroups.com>
Sent: Sunday, November 11, 2001 2:54 PM
Subject: Re: [ib-support] Weeknumber


Jörg,

look up Extract in the Docu.

iDoW = EXTRACT (WEEKDAY FROM ADate);

I think, iDoW = 1 stands means "Monday".

HTH,
Markus

At 13:50 11.11.2001 +0100, you wrote:
>Hi,
>
>I've a field which contains a date.
>
>Is there a simple way to find out the weeknumber?
>
>TIA,
>Jörg




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/