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

[Ivan Smahin]

Hello Ivan,

Thursday, December 9, 2004, 1:00:44 PM, you wrote:

IS> Hello Ruslan,

IS> 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'"
    
IS> Yes.
IS> '01:00:00.123' - the last three digits is milliseconds.
IS> You can omit ms in literals.




Sorry - it must be ':' as delimiter.
'01:00:00:123'

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