DateTime fields, methods over such fields, DateTime depended SQL where-clause and SQL-functions.

[Ivan Smahin]

Hello Ruslan,

Thursday, December 9, 2004, 9:53:17 AM, you wrote:

RZ> On 12/9/04 2:15 AM, "Ivan Smahin"
RZ> <IvanSmahin at public.kherson.ua> wrote:

RZ> Question: how in literal we specify the milliseconds?
RZ> It seems after DOT?

RZ>                  "fld3 < datetime'2004-01-01 01:00:00.123'"
    
Yes.
'01:00:00.123' - the last three digits is milliseconds.
You can omit ms in literals.



-- 
Best regards,
 Ivan                            mailto:IvanSmahin at public.kherson.ua