You could use a query like this: SELECT id, SUBSTRING_INDEX(SUBSTRING_INDEX(colors, ‘,’, n.digit+1), ‘,’, -1) color FROM colors INNER JOIN (SELECT 0 digit UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3) n ON LENGTH(REPLACE(colors, ‘,’ , ”)) <= LENGTH(colors)-n.digit ORDER BY id, n.digit Please see fiddle here. Please notice that this query … Read more
Generally Formatting numbers in JavaScript Formatting numbers for currency display and more. In jQuery autoNumeric (a decent number formatter & input helper with locale support for jQuery 1.5+) jQuery Format (a clientSide implementation of Java’s SimpleDateFormat and NumberFormat) jquery-numberformatter (number formatter with locale support)
The T is just a literal to separate the date from the time, and the Z means “zero hour offset” also known as “Zulu time” (UTC). If your strings always have a “Z” you can use: SimpleDateFormat format = new SimpleDateFormat( “yyyy-MM-dd’T’HH:mm:ss.SSS’Z'”, Locale.US); format.setTimeZone(TimeZone.getTimeZone(“UTC”)); Or using Joda Time, you can use ISODateTimeFormat.dateTime().
I do not believe Android supports full justification. UPDATE 2018-01-01: Android 8.0+ supports justification modes with TextView.
function formatAMPM(date) { var hours = date.getHours(); var minutes = date.getMinutes(); var ampm = hours >= 12 ? ‘pm’ : ‘am’; hours = hours % 12; hours = hours ? hours : 12; // the hour ‘0’ should be ’12’ minutes = minutes < 10 ? ‘0’+minutes : minutes; var strTime = hours + ‘:’ … Read more
Use the standard Java DateFormat class. For example to display the current date and time do the following: Date date = new Date(location.getTime()); DateFormat dateFormat = android.text.format.DateFormat.getDateFormat(getApplicationContext()); mTimeText.setText(“Time: ” + dateFormat.format(date)); You can initialise a Date object with your own values, however you should be aware that the constructors have been deprecated and you should … Read more
decimalVar.ToString(“#.##”); // returns “.5” when decimalVar == 0.5m or decimalVar.ToString(“0.##”); // returns “0.5” when decimalVar == 0.5m or decimalVar.ToString(“0.00”); // returns “0.50” when decimalVar == 0.5m
If the idea is to print integers stored as doubles as if they are integers, and otherwise print the doubles with the minimum necessary precision: public static String fmt(double d) { if(d == (long) d) return String.format(“%d”,(long)d); else return String.format(“%s”,d); } Produces: 232 0.18 1237875192 4.58 0 1.2345 And does not rely on string manipulation.
String.Format(“{0:n}”, 1234); // Output: 1,234.00 String.Format(“{0:n0}”, 9876); // No digits after the decimal point. Output: 9,876
The simplest answer, assuming you don’t mind the vagaries and variations in format between different platforms, is the standard %p notation. The C99 standard (ISO/IEC 9899:1999) says in §7.19.6.1 ¶8: p The argument shall be a pointer to void. The value of the pointer is converted to a sequence of printing characters, in an implementation-defined … Read more