biginsights - BigSheets DateTime Formatting -
i have csv being read bigsheets in biginsights 2.1.2. 1 of columns date in structure of mm/dd/yyyy. need convert column datetime format. when click on column name have option change data type datetime. gives me prompt enter format , select timezone. apparently i'm misunderstanding format does, because enter mm/dd/yyyy , fails convert data properly.
does know proper way use bigsheets , convert data mm/dd/yyyy datetime? thank you!
because output in datetime format, capitalization important here. putting mm/dd/yyyy in fact telling it read minute-minute/day-day/year-year-year-year. months denoted capital m's in format. when fixed mm/dd/yyyy able interpret input.
Comments
Post a Comment