Issue with date time column.

Hi,

Kindly help in rectifying an issue being faced with a date column. The value of my Date column is in the format 8/14/2018 9:34. Every minute data is available. I need to segregate to 3 new columns, Day,Month, Minute or hour.

In generate attribute I have given expressions like  MONTHS= date_get([Date], DATE_UNIT_MONTH, "GMT"),DAYS= date_get([Date], DATE_UNIT_DAY, "GMT"),MINUTE=date_get([Date], DATE_UNIT_MINUTE, "GMT").But the columns created are not producing the required results .For July month it shows as 5 for some rows and as 6 for others .Similarly for days  and minutes also the values produced are wrong. Tried changing the time zones to CET,IST .But sadly those too did not help. Kindly let me know where have I gone wrong. Awaiting response.

Thanks and regards,
nn_here