SELECT: UNIX_TIMESTAMP

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

const query = myQueryBuilder
    .SELECT({ $UNIX_TIMESTAMP: 'field' })
    .from('table')
    .get();

// SELECT UNIX_TIMESTAMP(`field`) FROM `table`

const query = myQueryBuilder
    .SELECT({ $UNIX_TIMESTAMP: { field: 'fieldUNIX_TIMESTAMP' } })
    .from('table')
    .get();

// SELECT UNIX_TIMESTAMP(`field`) AS `fieldUNIX_TIMESTAMP` FROM `table`