Exporting Dates to Tab Separated Values produces java code instead of text strings

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Import a text file. Do not auto-convert data
2. Use common transformations to convert column to Date type
3. Export as TSV

What is the expected output?
I expect a date in one of the common text strings, eg. YYYY/MM/DD or dd-mm-yyyy.

 What do you see instead?
java.util.GregorianCalendar[time=1246197600000,areFieldsSet=true,areAllFieldsSet
=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id=""Australia/Sydney"",offse
t=36000000,dstSavings=3600000,useDaylight=true,transitions=142,lastRule=java.uti
l.SimpleTimeZone[id=Australia/Sydney,offset=36000000,dstSavings=3600000,useDayli
ght=true,startYear=0,startMode=3,startMonth=9,startDay=1,startDayOfWeek=1,startT
ime=7200000,startTimeMode=1,endMode=3,endMonth=3,endDay=1,endDayOfWeek=1,endTime
=7200000,endTimeMode=1]],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=20
09,MONTH=5,WEEK_OF_YEAR=27,WEEK_OF_MONTH=5,DAY_OF_MONTH=29,DAY_OF_YEAR=180,DAY_O
F_WEEK=2,DAY_OF_WEEK_IN_MONTH=5,AM_PM=0,HOUR=0,HOUR_OF_DAY=0,MINUTE=0,SECOND=0,M
ILLISECOND=0,ZONE_OFFSET=36000000,DST_OFFSET=0]

What version of Google Refine are you using?
Version 2.0 [r1836]

What operating system and browser are you using?
Mac OS X 10.6.6, Safari Version 5.0.4 (6533.20.27)

Is this problem specific to the type of browser you're using or it happens
in all the browsers you tried?
I haven't bothered to test other browsers

Original issue reported on code.google.com by malc...@notyourhomework.net on 20 Mar 2011 at 11:12

• Merged into: #294

[GoogleCodeExporter]

See issue #294

Original comment by chima...@gmail.com on 21 Mar 2011 at 12:06

[GoogleCodeExporter]

Original comment by tfmorris on 21 Mar 2011 at 3:12

• Changed state: Duplicate