[TIP] Extracting some part of date, time and datetime values.

[Ruslan Zasukhin]

On 5/14/05 10:32 PM, "Claudius Sailer" <Claudius at sailer-online.de> wrote:

>> Don't use such code:
>> 
>> 
>>>> db.sqlExecute("update students set logged_in = substr(curdate(),
>>>> 1, 4) where
>>>> (ID = '4')");
>>>> 
>> 
>> Because of:
>> 
>> 1. We have a number of DateTime based SQL functions like YEAR(),
>> MONTH()...
>> 2. The string representation for such values may differ depending on
>> current DateTime format. So it's just unsafe.
> 
> but no possibility to get only date from CURDATE()!!
> This is very strong needed :-))

Why you think so ???

Ivan says exactly that we HAVE such possibility.

As I understand this should work:

    Year( now() )


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]