Hi,
I have a matrix in datetime format
'01-Jan-1983 00:00:00''01-Jan-1983 01:00:00''01-Jan-1983 02:00:00''01-Jan-1983 03:00:00''01-Jan-1983 04:00:00''01-Jan-1983 05:00:00''01-Jan-1983 06:00:00''01-Jan-1983 07:00:00''01-Jan-1983 08:00:00''01-Jan-1983 09:00:00''01-Jan-1983 10:00:00''01-Jan-1983 11:00:00''01-Jan-1983 12:00:00''01-Jan-1983 13:00:00''01-Jan-1983 14:00:00''01-Jan-1983 15:00:00''01-Jan-1983 16:00:00''01-Jan-1983 17:00:00''01-Jan-1983 18:00:00''01-Jan-1983 19:00:00''01-Jan-1983 20:00:00''01-Jan-1983 21:00:00''01-Jan-1983 22:00:00''01-Jan-1983 23:00:00'
I want to convert it to numeric format as follows:
1983 1 1 01983 1 1 11983 1 1 21983 1 1 31983 1 1 41983 1 1 51983 1 1 61983 1 1 71983 1 1 81983 1 1 91983 1 1 101983 1 1 111983 1 1 121983 1 1 131983 1 1 141983 1 1 151983 1 1 161983 1 1 171983 1 1 181983 1 1 191983 1 1 201983 1 1 211983 1 1 221983 1 1 23
What should be the syntax for this?
Best Answer