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.

beginning data enter format wrong data @ end

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

Popular posts from this blog

c++ - No viable overloaded operator for references a map -

java - Custom OutputStreamAppender not run: LOGBACK: No context given for <MYAPPENDER> -

java - Cannot secure connection using TLS -