Sprintf.js

Formatting with Sprintf.js

You can use standard sprintf() function for format dates and numbers:

    alasql.fn.sprintf = sprintf;
    var res = alasql('SELECT sprintf("%b",123)');

See full example in jsFiddle.