Hi,

I've had the same problems.

But finally I found it in the InterBase60 MigrationGuide.


HTH
Jörg

----- Original Message -----
From: "ibrahim Bulut" <ibrahim@...>
To: <ib-support@yahoogroups.com>
Sent: Monday, November 12, 2001 9:01 AM
Subject: [ib-support] Extract Function


> 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/
>
>
>
>
> 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/
>
>
>
>