| Subject | Re: [ib-support] days from January the 1st |
|---|---|
| Author | Duilio Foschi |
| Post date | 2002-03-02T11:29:57Z |
At 10.45 02/03/02 +0000, Lester wrote:
Now I only need a function that returns the current date and I will be able
to:
- extract the current year
- cast it into a varchar
- concatenate it with 01-01
- cast it into a date
The problem is: does that function exist ?
TYIA
Duilio
>Dialect 3?Dialect 1, but I discovered that EXTRACT works ok.
Now I only need a function that returns the current date and I will be able
to:
- extract the current year
- cast it into a varchar
- concatenate it with 01-01
- cast it into a date
The problem is: does that function exist ?
TYIA
Duilio