we are a worldwide company 24x7 and have many processes which span timezones and location business hours.

we have a table in our old system of business hours by country..   no problem, I can do that in SF too..

so I defined the default (us eastern), used the bulk loaded to extract it (to get the data format)

modeled my 187 records after that model

but bulk load fails with a ' need a sundastarttime', value provided incorrect.. 08:00:00.00Z

which matches exactly the extract format. hh:mm:ss.ttZ... timezone def

anyone have the magic incantation to help me understand this?

I can type them in.. but why do that...

Sam