Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have one field as below:
Time
4/22/2015 7:06:01 AM
3/20/2015 4:01:01 AM
3/20/2015 3:01:01 AM
2/12/2015 5:01:01 AM
1/15/2015 7:06:01 AM
2/10/2015 6:01:01 AM
2/14/2015 7:04:01 AM
1/08/2015 5:01:01 PM
Now i need to retrieve monthname, monthnumber and year from the above field values.
As I am planning to use monname as dimension in the barchart.
Thanks,
Durga
Hi,
Try this
month(Time) as Month,
num(month(Time)) as MonthNumber,
year(Time) as Year;
load * Inline [
Time
4/22/2015 7:06:01 AM
3/20/2015 4:01:01 AM
3/20/2015 3:01:01 AM
2/12/2015 5:01:01 AM
1/15/2015 7:06:01 AM
2/10/2015 6:01:01 AM
2/14/2015 7:04:01 AM
1/08/2015 5:01:01 PM
];
Regards,
Greeshma
Hi,
Try this
month(Time) as Month,
num(month(Time)) as MonthNumber,
year(Time) as Year;
load * Inline [
Time
4/22/2015 7:06:01 AM
3/20/2015 4:01:01 AM
3/20/2015 3:01:01 AM
2/12/2015 5:01:01 AM
1/15/2015 7:06:01 AM
2/10/2015 6:01:01 AM
2/14/2015 7:04:01 AM
1/08/2015 5:01:01 PM
];
Regards,
Greeshma
Load
month(Time) as Month,
num(month(Time)) as MonthNumber,
year(Time) as Year;
load Timestamp#(Time,'MM/DD/YYYY hh:mm:ss TT') As Time Inline [
Time
4/22/2015 7:06:01 AM
3/20/2015 4:01:01 AM
3/20/2015 3:01:01 AM
2/12/2015 5:01:01 AM
1/15/2015 7:06:01 AM
2/10/2015 6:01:01 AM
2/14/2015 7:04:01 AM
1/08/2015 5:01:01 PM
];
Hi durgabhavani,
Check this
Table1:
LOAD month(Time) as Month,
num(month(Time)) as MonthNumber,
year(Time) as Year;
LOAD * INLINE[
Time
4/22/2015 7:06:01 AM
3/20/2015 4:01:01 AM
3/20/2015 3:01:01 AM
2/12/2015 5:01:01 AM
1/15/2015 7:06:01 AM
2/10/2015 6:01:01 AM
2/14/2015 7:04:01 AM
1/08/2015 5:01:01 PM
];
Its working! Thanks Everyone!