how to separate date and time into 6 tables 01/01/2014 0:10:00? (year,mont​h,day,hour​s,minutes and second)

how to separate date and time into 6 tables 01/01/2014 0:10:00? (year,month,day,hours,minutes and second)

[Peter Perkins]

I'm gonna suggest that if 01/01/2014 0:10:00 represents a datetime, that you DON'T do that. You will likely be much happier with datetimes than six columns of numbers.

Answer 1

[Steven Lord]

Use the datevec function.

[Steven Lord]

I have no idea since I don't have your data nor have you stated what "its[sic] not related' means.

Show a small sample of data for which it gives a different answer than you expected and the exact datevec call you're executing. With that information we may be able to determine why it's not doing what you expect and how to modify the call.

[surya]

oke thank you ..