PHPackages                             visi/buddy-plugin-date-converter - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Utility &amp; Helpers](/categories/utility)
4. /
5. visi/buddy-plugin-date-converter

ActiveLibrary[Utility &amp; Helpers](/categories/utility)

visi/buddy-plugin-date-converter
================================

Manticore Search Buddy plugin to convert string dates to timestamps in WHERE clauses

01↓100%PHP

Since Feb 23Pushed 4mo agoCompare

[ Source](https://github.com/V-i-S-i/buddy-plugin-date-converter)[ Packagist](https://packagist.org/packages/visi/buddy-plugin-date-converter)[ RSS](/packages/visi-buddy-plugin-date-converter/feed)WikiDiscussions main Synced 4mo ago

READMEChangelogDependenciesVersions (1)Used By (0)

Manticore Buddy Plugin: Date Converter
======================================

[](#manticore-buddy-plugin-date-converter)

Automatically converts string dates to Unix timestamps in WHERE clauses when Manticore Search reports `unsupported filter type 'string'` errors.

Problem It Solves
-----------------

[](#problem-it-solves)

When you have timestamp fields in Manticore and accidentally use string dates in your queries, you get errors like:

```
SELECT * FROM mediamonitoring_today_lt WHERE date_added > '2025-12-01'
-- Error: unsupported filter type 'string' on attribute 'date_added'
```

This plugin automatically detects such errors and converts your query to:

```
SELECT * FROM mediamonitoring_today_lt WHERE date_added > 1733011200
-- Works perfectly!
```

Features
--------

[](#features)

- ✅ Detects `unsupported filter type 'string'` errors on timestamp fields
- ✅ Converts date strings like `'2025-12-01'` to Unix timestamps
- ✅ Supports date-time format: `'2025-12-01 14:30:00'`
- ✅ Works with all comparison operators: `>`, `=`, `&1 | grep "date-converter"
    ```

### Option 2: Manual Installation (Development)

[](#option-2-manual-installation-development)

1. **Clone the repository**:

    ```
    git clone https://github.com/YOUR_USERNAME/buddy-plugin-date-converter.git
    cd buddy-plugin-date-converter
    ```
2. **Copy to Manticore container**:

    ```
    docker cp . YOUR_CONTAINER:/usr/share/manticore/modules/manticore-buddy/plugins/buddy-plugin-date-converter
    ```
3. **Create autoloader** inside the container:

    ```
    docker exec YOUR_CONTAINER bash -c "cd /usr/share/manticore/modules/manticore-buddy/plugins/buddy-plugin-date-converter && mkdir -p vendor && cat > vendor/autoload.php
