Im new to using Julia - thanks in advance for the help.
The short story is that Im using ODBC and DataFrames to return query
results from a Postgres database, and Julia is changing the format of my
timestamps from the database, I think because it's automatically setting
them as DateTime types. Im not sure how to prevent this from happening, or
change the format that it's automatically setting after the result is set.
In the database, they are Postgres timestamp types and they look like this:
*2014-04-24
10:37:10 *
In Julia they look like this when set in the DataFrame: *2014-04-25T09:08:10
UTC *- Notice the extra T in the middle, and the timezone on the end.
Example:
julia> results = query("SELECT created FROM auditrecord LIMIT 10")
elapsed time: 6.7873e-5 seconds
10x1 DataFrame
|-------|-------------------------|
| Row # | created |
| 1 | 2010-11-29T17:21:06 UTC |
| 2 | 2010-11-29T17:22:46 UTC |
| 3 | 2010-11-29T17:26:08 UTC |
| 4 | 2010-11-29T17:34:55 UTC |
| 5 | 2010-11-29T17:36:16 UTC |
| 6 | 2010-11-29T17:36:18 UTC |
| 7 | 2010-11-29T17:38:40 UTC |
| 8 | 2010-11-29T17:39:40 UTC |
| 9 | 2010-11-29T17:41:19 UTC |
| 10 | 2010-11-29T17:43:34 UTC |
julia> eltype(results[1])
DateTime{ISOCalendar,Zone0}
I looked at the documentation for DateTime, and I see that I can change
formats, but Im not sure how to apply a format string to the array column.
(kinda wouldn't expect the following to magically change the formatting of
a whole array column but it's what I want to do) Im sure it's a newbie
mistake with a simple answer. Thanks for the help :)
julia> f = "yyyy-MM-dd HH:mm:ss"
"yyyy-MM-dd HH:mm:ss"
julia> datetime(f,results[1])
ERROR: no method datetime(ASCIIString,
DataArray{DateTime{ISOCalendar,Zone0},1})
