Unable to use FROM_UNIXTIME function

[selabie68]

Writing code like so:

$builder = new MySqlBuilder();

$query = $builder->select()
            ->setTable('invoices');

$columns['Invoice Number'] = 'invoice_number'; //Always Display
$query->setColumns($columns);
$query->setFunctionAsColumn('FROM_UNIXTIME', array('invoices.invoice_date', '%d/%m/%Y'), 'Date Entered');
$builder->write($query);

And it is returning MySQL that is invalid:

SELECT `invoices`.`invoice_number` AS `Invoice Number`, ``.`FROM_UNIXTIME(invoices.invoice_date, %d/%m/%Y)` AS `Date Entered` FROM `invoices`

[nilportugues]

@anarcist69 it is indeed a bug, as the GenericBuilder is outputting the expected query.

I'll look into it today. It shouldn't be too hard to fix.

Thanks for reporting, I'll keep you posted

[nilportugues]

Fixed it. 3dca30b

Use release 1.2.1 👍

[selabie68]

Thanks, almost got it. Looks like it still isn't outputting quite right.

MySQL requires formatting like this:

FROM_UNIXTIME(invoices.invoice_date, "%d/%m/%Y")

output is like this (Note the spaces after % signs and no quotation marks surrounding the second argument):

FROM_UNIXTIME(invoices.invoice_date, % d /% m /% Y)

Thanks for responding so fast.

EDIT:

Sorry shouldn't have responded so fast.

Changed my code to include the quotation marks and all is fine in the world again.

$query->setFunctionAsColumn('FROM_UNIXTIME', array('invoices.invoice_date', '"%d/%m/%Y"'), 'Date Entered');

@changetip, send coffee to @nilopc

[changetip]

Hi @nilopc, @anarcist69 sent you a tip worth 1 coffee (4,060 bits/$1.50), and I'm here to deliver it ➔ collect your tip.

Learn more about ChangeTip