Support of conversion of millisecond Unix time to Refine datetime

thagale / google-refine

Automatically exported from code.google.com/p/google-refine

Other

0 stars 0 forks source link

Support of conversion of millisecond Unix time to Refine datetime #609

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago

It would be nice to have a function such as FORMAT_UTC_USEC to convert Unix 
time ( which is a number) to a Datatime format, and to extract only 
year/month/day

Original issue reported on code.google.com by to...@benmoshe.com on 15 Sep 2012 at 11:52

GoogleCodeExporter commented 8 years ago

Can you provide a reference for the definition of this function?

Since we already provide a variety of date formatting functions, I'm guessing 
that what you really need is to be able to convert from a microsecond Unix time 
(ie Unix time multiplied by 1,000,000) to a Refine DateTime data type.  From 
there you would be able to use any of the standard date functions.

Original comment by tfmorris on 18 Sep 2012 at 3:31

Changed title: Support of conversion of millisecond Unix time to Refine datetime
Changed state: Accepted
Added labels: Type-Enhancement
Removed labels: Type-Defect

GoogleCodeExporter commented 8 years ago

Yes, it is very common to get the timestamp in microsecond unix time, a google 
example can be seen at rbig query functions 
https://developers.google.com/bigquery/docs/query-reference#timestampfunctions, 
but there are many other places you use it... 
Axtuwlly, I wanted to use refine as part of automatic pre processing of data I 
am getting, and was wondering on size of input, and do it all in thbwckgrounf 
before loading csv to big query...

Original comment by to...@benmoshe.com on 18 Sep 2012 at 7:53

GoogleCodeExporter commented 8 years ago

what is the solution to converting numeric date in milliseconds to a human 
readable date format in 2.5 version of this product?

Original comment by Rajeev....@gmail.com on 27 Nov 2012 at 8:27