Welcome to the Cloudera Community

Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Who agreed with this topic

Is there an option to set stating day of the week to be Sunday

avatar
New Contributor

Hi

 

Is there an option to set stating day of the week to be Sunday so when calling  trunc(timestamp, string unit) with 'D' I will get the date of Sunday and not of Monday

 

This can be done in oracle if you set the NLS_TERRITORY or alike  but I could not find how to set it in impala

 

 

Regards,

 

Noam

Who agreed with this topic