PHP - Access MSSQL datetime column from the returned array

Question

Array
(
    [0] => Array
        (
            [CallId] => 45
            [CallLoginId] => 1
            [CustomerId] => 140
            [CallOptionId] => 2
            [CallTypeId] => 2
            [CallStatusId] => 1
            [CallDateTime] => DateTime Object
                (
                    [date] => 2012-06-28 00:00:00
                    [timezone_type] => 3
                    [timezone] => Asia/Kolkata
                )

            [ContactNo] => 45151551115
            [ContactPerson] => Contact Person name
            [ProductId] => 1
            [ProdCompanyId] => 1
            [ProdCategoryId] => 1
            [ModelNo] => 451212151
            [ProdUnderId] => 1
            [Problem] => Simple Problem Details 
            [Remarks] => Remarks 
            [Accessories] => Accessories 
            [CallCaseId] => 
            [CallCaseDate] => 
            [ServiceCharge] => 0
            [CourierName] => 
            [DocketNo] => 
            [CompanyId] => 126
            [ASPId] => 130
            [InsBy] => 134
            [InsDate] => DateTime Object
                (
                    [date] => 2012-06-23 17:04:51
                    [timezone_type] => 3
                    [timezone] => Asia/Kolkata
                )

            [UpdBy] => 11
            [UpdDate] => DateTime Object
                (
                    [date] => 2012-06-28 18:29:23
                    [timezone_type] => 3
                    [timezone] => Asia/Kolkata
                )

            [FName] => Kumar
            [MName] => a
            [LName] => Customer
            [ProductName] => LenovoDesktop420
            [CallOption] => InHouse
            [CallType] => H.W.Installation
            [ProdCompany] => Lenovo
            [ProdCategory] => Desktop
            [ProdUnder] => AMC
            [CallStatus] => Open
            [EntityId] => 134
            [InsertBy] => Bhavin   Rana
        )

)

how can access date time value form this returned array ? thanks in advance.

Michael Berkowski · Accepted Answer · 2012-07-04 13:32:17Z

2

You have an outer array with numerically indexed one element [0], which is an associative array. CallDateTime as a key of that array is a DateTime object.

$array[0]['CallDateTime']->format('Y-m-d H:i:s')  // 2012-06-28 00:00:00
$array[0]['CallDateTime']->getTimezone()->getName()    // Asia/Kolkata

// Same with InsDate and UpdDate
$array[0]['InsDate']->format('Y-m-d H:i:s')         // 2012-06-23 17:04:51
$array[0]['InsDate']->getTimezone()->getName()           // Asia/Kolkata

edited Jul 4, 2012 at 13:32

answered Jul 4, 2012 at 12:31

Michael Berkowski

271k47 gold badges452 silver badges395 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Bhavin Rana Over a year ago

Fatal error: Cannot use object of type DateTime as array in C:\inetpub... where echo $this->CallDetail [0]['ContactNo']; works fine.

Michael Berkowski Over a year ago

@BhavinRana Oops sorry I misread the data structure. Those are objects and therefore you need to access their properties via ->

Bhavin Rana Over a year ago

tried with echo $this->CallDetail[0]['CallDateTime']->date ; Notice: Undefined property: DateTime::$date in C:\inetpub\...

Michael Berkowski Over a year ago

var_dump($this->CallDetail[0]['CallDateTime']). The property is clearly there from your structure above.

Bhavin Rana Over a year ago

above var_dump = object(DateTime)#85 (3) { ["date"]=> string(19) "2012-06-28 00:00:00" ["timezone_type"]=> int(3) ["timezone"]=> string(12) "Asia/Kolkata" }

|

Collectives™ on Stack Overflow

PHP - Access MSSQL datetime column from the returned array

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related