PDA

View Full Version : question with date/time comparison with predicate in core data




jliu69
Jun 23, 2009, 10:00 PM
Hi,

I'm new to the core data with the iphone cocoa program. In my application I need to use core data with predicate to query the SQLite database.

It has a date field with the data type as TimeStamp. I try to use the SQLite function datetime(), as :

datetime(arrive_time) < datetime('2009-06-23 11:30:00')

but it has the compilation error. And when I used the datetime() function in one side, like :

arrive_time < datetime('2009-06-23 11:30:00')

Can I use the NSDate object to pass into the predicate format string directly and do the comparison?

Thanks much,

jliu69