Type Conversion
***************

.[perex]
Nette Database automatically converts values returned from the database to the corresponding PHP types.


Date and Time
-------------

Time values are converted to `Nette\Utils\DateTime` objects. If you want time values to be converted to immutable `Nette\Database\DateTime` objects, set the `newDateTime` option to true in the [configuration |configuration].

```php
$row = $database->fetch('SELECT created_at FROM articles');
echo $row->created_at instanceof DateTime; // true
echo $row->created_at->format('j. n. Y');
```

In the case of MySQL, the `TIME` data type is converted to `DateInterval` objects.


Boolean Values
--------------

Boolean values are automatically converted to `true` or `false`. For MySQL, `TINYINT(1)` is converted if we set `convertBoolean` in the [configuration |configuration].

```php
$row = $database->fetch('SELECT is_published FROM articles');
echo gettype($row->is_published); // 'boolean'
```


Numeric Values
--------------

Numeric values are converted to `int` or `float` according to the column type in the database:

```php
$row = $database->fetch('SELECT id, price FROM products');
echo gettype($row->id);    // integer
echo gettype($row->price); // float
```


Custom Normalization
--------------------

Using the `setRowNormalizer(?callable $normalizer)` method, you can set a custom function for transforming rows from the database. This is useful, for example, for automatic data type conversion.

```php
$database->setRowNormalizer(function(array $row, ResultSet $resultSet): array {
	// type conversion happens here
	return $row;
});
```