How to split time and date?

[#1]

This is the format I have. Now I want to split into Year, Month Year, Date, Week, Month and Time.

Can anyone help me out please.

[venkatg6759]

For

Year use

Year(Fieldname)

MonthYear

monthName

Date  use

date or date# or timestamp or timestamp#

Week use

Week(fieldname)

month and time

Use

Month (Field) &' '& Time(Field)

[#3]

Try

Year(field),Month(field),Date(),Week(),Time() correspondingly

[its_anandrjs]

Try with the scripts

LOAD

DateColumn,

Date(Timestamp#(DateColumn,'MM-DD-YY hh:mm TT'),'MM-DD-YY') as NewDateColumn,

Year(Timestamp#(DateColumn,'MM-DD-YY hh:mm TT')) as Year,

Month(Timestamp#(DateColumn,'MM-DD-YY hh:mm TT')) as Month,

MonthName(Timestamp#(DateColumn,'MM-DD-YY hh:mm TT')) as MonthYear,

Week(Timestamp#(DateColumn,'MM-DD-YY hh:mm TT')) as Week,

Time(Mid(Timestamp#(DateColumn,'MM-DD-YY hh:mm TT'),10,5),'hh:mm') as Time;

LOAD * Inline

[

DateColumn

10-24-13 12:00 AM

10-25-13 12:00 AM

10-26-13 12:00 AM

10-27-13 12:00 AM

10-28-13 12:00 AM

10-29-13 12:00 AM

10-30-13 12:00 AM

];

[its_anandrjs · Accepted solution]

If you have perfect timestamp filed then use

Date(DateField) as NewDateColumn,

Year(DateField) as Year,

Month(DateField) as Month,

MonthName(DateField) as MonthYear,

Week(DateField) as Week,

Time(DateField) as Time

[maxgro]

floor(field) to get the date

frac(field) to get the time