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

Sun May 15 11:45:14 CDT 2005

Am 15. Mai 2005 um 10:05 Uhr schrieb Ruslan Zasukhin:

>> Sorry this is a missunderstanding. What I want is not YEAR or MONTH.
>> I want the DATE
>>
>> I have
>> 15.05.2005 20:11:10.564
>>
>> I want
>> 15.05.2005
>>
>> IMHO I can only solve this by using RB XXX.nthfield(" ",1)
>> not inside V4RB2-SQL or did I missed something?
>>
>
> Ok, Ivan will add for next build
>
>     date GETDATE( datetime )
>     time GETTIME( datetime )

Great.
Thanks a lot.

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!!! ]