You are currently viewing the 0.10 branch api documentation. Switch to 1.0 or 1.1

0.10 Doctrine_Expression_Mssql

Doctrine Expression Mssql

Inheritence

Doctrine_Expression_Mssql  < Doctrine_Expression_Driver  < Doctrine_Connection_Module

Method Summary

Returns Name Description
string concat
string guid
string now There are three special variables for current date and time:

  • CURRENT_TIMESTAMP (date and time, TIMESTAMP type)

  • CURRENT_DATE (date, DATE type)

  • CURRENT_TIME (time, TIME t
string substring

Methods inherited from Doctrine_Expression_Driver

pi , upper , avg , md5 , add , between , length , ltrim , __call , trim , cos , regexp , not , mul , substring , rtrim , neq , in , mod , now , sum , isNull , sub , lte , sin , gte , count , getIdentifiers , guid , max , eq , getIdentifier , round , lt , gt , div , lower , isNotNull , soundex , concat , acos , locate , min

Method Details

  • (string) concat($arg1, $arg2, $values...)

    Returns string to concatenate two or more string parameters

    Doctrine_Expression_Mssql


  • (string) guid()

    Returns global unique identifier

    Doctrine_Expression_Mssql


  • (string) now($type = 'timestamp')

    Return string to call a variable with the current timestamp inside an SQL statement

    There are three special variables for current date and time:



    • CURRENT_TIMESTAMP (date and time, TIMESTAMP type)




    • CURRENT_DATE (date, DATE type)




    • CURRENT_TIME (time, TIME t

      Doctrine_Expression_Mssql


  • (string) substring($value, $position, $length = null)

    return string to call a function to get a substring inside an SQL statement

    Doctrine_Expression_Mssql