The return value of FORMAT_DATE('%u', date)

[nishioka-wemex]

I have been using your bigquery-emulator and I greatly appreciate the effort and dedication you have put into this project.

In using it, I discovered a discrepancy between the BigQuery behavior and the emulator's behavior. The function FORMAT_DATE('%u', date) in your emulator returns the week number of the year , which I noticed differs from BigQuery's functionality. In BigQuery, this function is intended to return The weekday (Monday as the first day of the week) as a decimal number (1-7) instead.

ref: https://cloud.google.com/bigquery/docs/reference/standard-sql/format-elements#format_elements_date_time

Could you please consider revising the emulator's FORMAT_DATE('%u', date) function?

Let me know if you need any additional information or clarification on this issue.