Dates in OQL in Data Access, formerly OpenAccess ORM OQL (OQL specific questions)

Robert

6 posts

Member since:
Sep 2008

Posted 27 Feb 2009 Link to this post

Hello All,

How do you represent dates in an OQL Query?

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

PetarP

Admin

754 posts

Posted 27 Feb 2009 Link to this post

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

9 posts

Member since:
Dec 2008

Posted 31 Mar 2009 Link to this post

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.