Try
'Post.added' =-!CURRENT_DATE
or
'Post.added' =-!SYS_DATE
The -! symbol tells cake 1.2 to not try to parse the oracle function
in the condition as a string.
Raphael Spindell
http://www.webspin.biz
On Jan 22, 10:45 pm, Chris [EMAIL PROTECTED] wrote:
I am using CakePHP 1.2
'BlogsPost.publish_at' =-!SYS_DATE
gives a query of
(BlogsPost.publish_at = ' -!SYS_DATE')
So it doesn't appear to be working.
Anyone know how to see the field data type?
On Jan 23, 5:57 am, WebSpin.Biz [EMAIL PROTECTED] wrote:
Try
'Post.added' =-!CURRENT_DATE
or
works:
'BlogsPost.publish_at' = -!TO_DATE(' . date('Y-m-d H:i:s') .
','-MM-DD HH24:MI:SS')
does not work:
'BlogsPost.publish_at' = -!TO_DATE(' . date('Y-m-d H:i:s') .
','-MM-DD HH24:MI:SS')
notice the space after the ^
Thanks Raphael.
I am using CakePHP 1.2 and Oracle.
I am trying to figure out how to tell the find function in a
controller that a field in the condition statement is something other
than a string.
I am trying to do a comparison on a datetime field in the Oracle db.
so I have:
code