Attachments do not show on the mail list, perhaps just type out an example.
--Andries
> On Aug 2, 2016, at 1:56 PM, Joseph Blue <jblue@maprtech.com> wrote:
>
> My bad on the formatting. Here is a screen shot of the query. Note bad m/d/y and hour=min=sec=0.0
>
>
> On Tue, Aug 2, 2016 at 1:46 PM, Joseph Blue <jblue@maprtech.com <mailto:jblue@maprtech.com>>
wrote:
> The field I have is a timestamp. The date is obviously in wrong order in the time stamp
(I can break it up and reassemble to get a good date, so no problem there).
> I do not seem to be able to get the hour of the day using the date_parts, so that data
seems obscured.
> Any ideas how to get the 2 o'clock time out of this field?
>
> Query...
> select
> Datatime_start,
> date_part('day',Datatime_Start) `day`,
> date_part('month',Datatime_Start) `month`,
> date_part('year',Datatime_Start) `year`,
> date_part('hour',Datatime_Start) `hour`,
> date_part('minute',Datatime_Start) `minute`
> from dfs.tmp.tv <http://dfs.tmp.tv/>
> limit 5
>
> Results....
>
> Datatime_start
> day
> month
> year
> hour
> minute
> Datatime_start
> day
> month
> year
> hour
> minute
> 28/04/16 2:00 16 4 2028 0 0 28/04/16 2:00 16 4 2028 0 0 28/04/16 2:00 16 4 2028 0 0 28/04/16
2:00 16 4 2028 0 0
>
>
>
>
>
>
> --
> Joseph Blue
> Data Scientist
> jblue@maprtech.com <mailto:jblue@maprtech.com> | www.mapr.com <http://www.mapr.com/>
> Mobile: 858-357-4926 <tel:858-357-4926>
>
>
>
>
>
>
> --
> Joseph Blue
> Data Scientist
> jblue@maprtech.com <mailto:jblue@maprtech.com> | www.mapr.com <http://www.mapr.com/>
> Mobile: 858-357-4926
>
|