setDateFormat() публичный Метод

Set oracle session date format.
public setDateFormat ( string $format = 'YYYY-MM-DD HH24:MI:SS' )
$format string
Пример #1
0
<?php

require 'vendor/autoload.php';
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(-1);
use Illuminate\Database\Capsule\Manager as Capsule;
use yajra\Oci8\Connectors\OracleConnector;
use yajra\Oci8\Oci8Connection;
$capsule = new Capsule();
$manager = $capsule->getDatabaseManager();
$manager->extend('oracle', function ($config) {
    $connector = new OracleConnector();
    $connection = $connector->connect($config);
    $db = new Oci8Connection($connection, $config["database"], $config["prefix"]);
    // set oracle date format to match PHP's date
    $db->setDateFormat('YYYY-MM-DD HH24:MI:SS');
    return $db;
});
$username = $params['username'];
$password = $params['password'];
$host = $params['host'];
$database = $params['database'];
$capsule->addConnection(array('driver' => 'oracle', 'host' => $host, 'database' => $database, 'username' => $username, 'password' => $password, 'prefix' => '', 'port' => 1521));
$capsule->bootEloquent();