I am loading data from a data warehouse. I have are dates and some which are times. The times ones are fine but the date fields are loadign as dd/mm/yyyy hh:mm. As I already have a separate time field I don't require that portion of this field. Is there a simple way to correct this in the load statement.?
floor(MyDate) will remove the time fraction. Note, MyDate must be a date type and not a string. If it's a string you can use the date# function first to make it a date.
floor(MyDate) will remove the time fraction. Note, MyDate must be a date type and not a string. If it's a string you can use the date# function first to make it a date.
Thank you -that works great. Now I've just got to take the seconds off one of my time fields so I can do utilisation. The data is all over the place, which just makes the development so much harder.
Thank you -that works great. Now I've just got to take the seconds off one of my time fields so I can do utilisation. The data is all over the place, which just makes the development so much harder.
