How do i create a column with the Crew name based on Date_Time ?

Thank you for your response.

I already have a DATE table on my schema, i would need to create a new one right?

So it would be like...Year -> Month -> Day -> Half day -> Hour -> Minute -> Second, a column for each one

i would have to add the crew name to the date manually then, right?

it is complicated to get it add it dynamically.

Thanks.