makedate - 指令碼與圖表函數

SET DateFormat='DD/MM/YYYY'; SET TimestampFormat='DD/MM/YYYY h:mm:ss[.fff] TT'; SET FirstWeekDay=0; SET BrokenWeeks=1; SET ReferenceDay=0; SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'; SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';   Transactions: Load *, MakeDate(transaction_year, transaction_month, transaction_day) as "Transaction Date", ;   Load * Inline [ transaction_id, transaction_year, transaction_month, transaction_day, transaction_amount, transaction_quantity, discount, customer_id, size, color_code 3750, 2018, 08, 30, 12423.56, 23, 0,2038593, L, Red 3751, 2018, 09, 07, 5356.31, 6, 0.1, 203521, m, orange 3752, 2018, 09, 16, 15.75, 1, 0.22, 5646471, S, blue 3753, 2018, 09, 22, 1251, 7, 0, 3036491, l, Black 3754, 2018, 09, 22, 21484.21, 1356, 75, 049681, xs, Red 3756, 2018, 09, 22, -59.18, 2, 0.333333333333333, 2038593, M, Blue 3757, 2018, 09, 23, 3177.4, 21, .14, 203521, XL, Black ];