SELECT: DATE_FORMAT

Ali Amirnezhad edited this page Jul 24, 2019 · 1 revision

const query = myQueryBuilder
    .SELECT({ $DATE_FORMAT: 'field', $ARGS: ['$%Y-%m-%d %h:%i:%s'] })
    .from('table')
    .get();

// SELECT DATE_FORMAT(`field`, '%Y-%m-%d %h:%i:%s') FROM `table`

const query = myQueryBuilder
    .SELECT({ $DATE_FORMAT: { field: 'fieldDATE_FORMAT' }, $ARGS: ['$%Y-%m-%d %h:%i:%s'] })
    .from('table')
    .get();

// SELECT DATE_FORMAT(`field`, '%Y-%m-%d %h:%i:%s') AS `fieldDATE_FORMAT` FROM `table`