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

Sun May 15 11:05:03 CDT 2005

On 5/15/05 10:01 AM, "Claudius Sailer" <Claudius at sailer-online.de> wrote:

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

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