cakephp-1.3 > TimeHelper :: daysAsSql()
A AclBase AclBehavior AclComponent AclNode AclShell Aco AcoAction AjaxHelper ApcEngine ApiShell App AppController AppController AppHelper AppHelper AppModel AppModel Aro AuthComponent B BakeShell BakeTask BehaviorCollection C Cache CacheEngine CacheHelper CakeErrorController CakeLog CakeRoute CakeSchema CakeSession CakeSocket ClassRegistry Component Configure ConnectionManager ConsoleShell ContainableBehavior Controller ControllerTask CookieComponent D DataSource DbAcl DbAclSchema DbConfigTask DboMssql DboMysql DboMysqlBase DboMysqli DboOracle DboPostgres DboSource DboSqlite Debugger Dispatcher E EmailComponent ErrorHandler ErrorHandler ExtractTask F File FileEngine FileLog FixtureTask Folder FormHelper H Helper HtmlHelper HttpSocket I I18n I18nModel i18nSchema I18nShell Inflector IniAcl J JavascriptHelper JqueryEngineHelper JsBaseEngineHelper JsHelper L L10n M MagicDb MagicFileResource MediaView MemcacheEngine Model ModelBehavior ModelTask MootoolsEngineHelper Multibyte N NumberHelper O Object Overloadable Overloadable Overloadable2 Overloadable2 P PagesController PagesController PaginatorHelper Permission PluginShortRoute PluginTask ProjectTask PrototypeEngineHelper R RequestHandlerComponent Router RssHelper S Sanitize Scaffold ScaffoldView SchemaShell Security SecurityComponent SessionComponent SessionHelper SessionsSchema Set Shell ShellDispatcher String T TemplateTask TestSuiteShell TestTask TextHelper ThemeView TimeHelper TranslateBehavior TreeBehavior V Validation View ViewTask X XcacheEngine Xml XmlElement XmlHelper XmlManager XmlNode XmlTextNode

daysAsSql

line:264 at /cake/libs/view/helpers/time.php
Returns a partial SQL string to search for all records between two dates.

Method

(string) daysAsSql ($begin, $end, $fieldName, $userOffset = null)

Parameters

ParameterTypeCommentDefault
$begin ? string required Datetime string or Unix timestamp
$end string required Datetime string or Unix timestamp
$fieldName string required Name of database field to compare with
$userOffset int optional User's offset from GMT (in hours) null

Return

string

Comment

Returns a partial SQL string to search for all records between two dates.

@param string $dateString Datetime string or Unix timestamp
@param string $end Datetime string or Unix timestamp
@param string $fieldName Name of database field to compare with
@param int $userOffset User's offset from GMT (in hours)
@return string Partial SQL string.
@access public
@link http://book.cakephp.org/view/1471/Formatting