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

[Claudius Sailer]

Hi,

Am 14. Mai 2005 um 20:37 Uhr schrieb Ivan Smahin:

> Hello All,
>
> 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 :-))

bye


Claudius

-- 
G4/733 QS / MacOS X 10.4de / RB 5.5.3de/ Valentina 1.10.0 & 2.0.3
Homepage    http://www.ClaSai.de
iChat        ryhoruk
RealBasic ListBoxes: [ I feel the need...the need for speed!!! ]