Locale:
arrow_drop_down
Applicable to date, number, currency and percent type columns
BG
EN
DE
FR
JA
DateTime format:
arrow_drop_down
Applied to 'dateTime' type column only
short
long
full
Date format:
arrow_drop_down
Applied to 'date' type column only
shortDate
mediumDate
longDate
fullDate
Time format:
arrow_drop_down
Applied to 'time' type column only
shortTime
mediumTime
longTime
fullTime
Timezone:
arrow_drop_down
Applicable to dateTime type columns only
GMT
UTC+9:30/ +10:30
UTC+0
UTC-6
UTC+1
UTC+3
Currency Code:
arrow_drop_down
Applicable to currency type columns
USD
BGN
EUR
JPY
Set digits info
Decimal representation options, specified by a string in the following format: minIntegerDigits.minFractionDigits-maxFractionDigits
clear
Applicable to number, currency and percent type columns
Prod. Name
arrow_upward
more_vert
Image
Unit Price
arrow_upward
more_vert
Order Full Date
arrow_upward
more_vert
Order Date
arrow_upward
more_vert
Order Time
arrow_upward
more_vert
Stock Value
arrow_upward
more_vert
% Change
arrow_upward
more_vert
Chai
18.0000
February 12, 2012 at 3:20:00 AM GMT+0
Feb 12, 2012
3:20 AM
$39.0000
3.0000%
Chang
19.0000
March 17, 2003 at 5:40:00 AM GMT+0
Mar 17, 2003
5:40 AM
$17.0000
4.0000%
Aniseed Syrup
10.0000
March 17, 2006 at 1:55:00 AM GMT+0
Mar 17, 2006
1:55 AM
$13.0000
7.0000%
Chef Antons Cajun Seasoning
22.0000
March 17, 2016 at 11:11:00 AM GMT+0
Mar 17, 2016
11:11 AM
$53.0000
3.0000%
Chef Antons Gumbo Mix
21.3500
Nov 11, 2011
$0.0000
3.0000%
Grandmas Boysenberry Spread
25.0000
December 17, 2017 at 2:15:00 AM GMT+0
Dec 17, 2017
2:15 AM
$0.0000
3.0000%
Uncle Bobs Organic Dried Pears
30.0000
July 17, 2016 at 1:55:00 AM GMT+0
Jul 17, 2016
$150.0000
3.0000%
Northwoods Cranberry Sauce
40.0000
January 17, 2018 at 1:55:00 AM GMT+0
Jan 17, 2018
$6.0000
3.0000%
Mishi Kobe Niku
97.0000
February 17, 2010 at 8:10:00 AM GMT+0
Feb 17, 2010
8:10 AM
$29.0000
3.0000%
Row added
SHOW
Count
9
Count
9
Min
10.0000
Max
97.0000
Sum
282.3500
Avg
31.3722
Count
9
Earliest
March 17, 2003 at 5:40:00 AM GMT+0
Latest
January 17, 2018 at 1:55:00 AM GMT+0
Count
9
Earliest
Mar 17, 2003
Latest
Jan 17, 2018
Count
9
Earliest
1:55 AM
Latest
11:11 AM
Count
9
Min
$0.0000
Max
$150.0000
Sum
$307.0000
Avg
$34.1111
Count
9
Min
3.0000%
Max
7.0000%
Sum
32.0000%
Avg
3.5556%