What steps will reproduce the problem?
1. Load some dataset containing dates
2. Convert dates from any text format using toDate() function
3. Now dates are displayed in grid like 2009-01-21T00:00:00Z
4. Align columns to freebase schema so column with dates will be property with
type /type/datetime
5. Load data into freebase sandbox
6. refinery.freebaseapps.com says:
LOAD_TRIPLE triple is not valid to be loaded (ERROR): Invalid literal Wed Jan
21 00:00:00 MSK 2009 of type /type/datetime: Literal value (Wed Jan 21 00:00:00
MSK 2009) must be valid mql datetime
"$Name_en_0" --(/internet/website/launched)--> "Wed Jan 21 00:00:00 MSK 2009"
[{"recon":{"s":"rec1289912419390812104"}}]
What is the expected output? What do you see instead?
Expecting that date type should be converted into freebase date format
transparently.
What version of the product are you using? On what operating system?
2.0-r1836
Windows XP i386 32-bit
Oracle Java 6 update 22 (build 1.6.0_22-b04)
Please provide any additional information below.
Maybe related to issue 90 (toString() format parameter is ignored):
http://code.google.com/p/google-refine/issues/detail?id=90
Original issue reported on code.google.com by incredible.angst on 16 Nov 2010 at 10:50
Original issue reported on code.google.com by
incredible.angston 16 Nov 2010 at 10:50