Dates in OQL

[Robert]

Hello All,

How do you represent dates in an OQL Query?

i.e. somthing like  select * from classextent where DueDate>???????

[PetarP]

Hi Robert,
the best wayis to pass it as a parameter like:

IObjectScope scope = ObjectScopeProvider1.GetNewObjectScope();
            string query = "select * from EmployeeExtent as x where x.BirthDate> $1";
            scope.Transaction.Begin();
            var result = scope.GetOqlQuery(query).Execute(DateTime.Parse("1/1/1962"));
            foreach (Employee emp in result)
            {
                Console.WriteLine( emp.BirthDate);
            }
            scope.Transaction.Commit();
            scope.Dispose();
            Console.ReadKey();

Best wishes,
PetarP
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Majid]

 

 

 

query = "...........  X.startTime >= timestamp '" + date.ToString("yyyy-MM-dd HH:mm:ss") + "' AND X.startTime < timestamp '" + date.Add(new TimeSpan(1,0,0,0)).ToString("yyyy-MM-dd HH:mm:ss") + "' ORDER BY X.startTime DESC";


This will work. To find any thing on specific date. For your program adjust it your self.